Forum Discussion
Search for a number in another sheet and replace with a different column name
I have multiple sheets in an excel file. Sheet1 has multiple columns, first column is barcode(for eg. 5463577263). I want to find this barcode in sheet2 and grab required fields using vlookup. Th...
Hi Srini,
For data like this
the formula could be
=INDEX($D$1:$D$5,MATCH(1,INDEX(--(VALUE(LEFT($C$1:$C$5,10))=$A$1),),0))
and attached
Sergei, Thank you very much for your quick response on this. You saved me lot of time to solve this.
Srini, you are welcome
