Plzzzz Help,
I have the following data in sheet1.
P.Code Material Description ShortDescription
31011000 12.00-20 TUBE 12.00-20
31011500 12.00-20 INS TUBE 12.00-20
31021000 11.00-20 TUBE 11.00-20
31021500 11.00-20 INS TUBE 11.00-20
31021510 11.00-20 MT INS TUBE 11.00-20
31031000 10.00-20 INS TUBE 10.00-20
31031100 10.00-20 MT TUBE 10.00-20
31031300 10.00-20 PLUS TUBE 10.00-20
31031400 10.00-20 TRADE TUBE 10.00-20
31031500 10.00-20 OE TUBE 10.00-20
31031510 10.00-20 MT INS TUBE 10.00-20
31031520 10.00-20 TR INS TUBE 10.00-20
31031600 10.00-20 FT INS TUBE 10.00-20
31031610 10.00-20 FT TUBE 10.00-20
and the data in sheet2 is:
A B C
1 Material Description ShortDescription Stk
2 11.00-20 MT INS TUBE 1
3 10.00-20 MT INS TUBE 271
4 10.00-20 TR INS TUBE 1
5 10.00-20 FT INS TUBE 9
6 10.00-20 FT TUBE 1
I need a formula in cell B2 of sheet2 to lookup the value of A2 from sheet1 in "ShortDescription" column.
Vlookup is not working here because of multiple results value. kindly help....!!!
PS : I have also attached my file.
Bookmarks