ayrus
09-17-2018, 03:36 AM
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..
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..