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