hello all
Please see attached
Scrap Tab – K6 = i need a formula to look up Part number in A and return the pallet from the VMS tab
Currently using VLOOKUP however this finds 1 lot of data, sometimes there can be 2 or 3 lots different pallet numbers as highlighted in yellowon the VMS tab
Expected results highlighted in yellow in K6 – So the formula will advise me what pallet numbers the part numbers appear on
Paul
Bookmarks