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..