Forum Discussion
VLOOKU
I have 2 sheets, sheet 2 has Part description and Part Number in 2 columns. Part 1 Part No 1 Part 2 Part No 2 Part 3 Part No 3 Part 4 ...
Simply reference the sheet in your lookup formula
=VLOOKUP(A2,Sheet2!A:B,2,FALSE)