Search & Index

[ayrus]

Hi,

Can someone please guide me with Search and Index using VBA (understand this is a faster routine as compared to VLOOKUP)


Wish to lookup Descp data from Masterdata (which is available in another sheet) automatically.

my Sample Data






ID

Descp


AB1
??


AB2
??


AB2
??


AB2
??


AB2
??


BC1
??


BC1
??


BC3
??


BC3
??


BC1
??


AB4
??


AB4
??


AB4
??







Master Data






ID

Descp



AB1
AB1 Product


AB2
AB2 Product


AB3
AB3 Product


AB4
AB4 Product


AB5
AB5 Product


BC1
BC1 Product


BC2
BC2 Product


BC3
BC3 Product





Many thanks..

[Jan Karel Pieterse]

I would be very surprised if a VBA UDF would be faster than VLOOKUP.

[ayrus]

Thank you guys; was able to solve this...