What is the name of the sheet containing the parts list
Which column in that sheet contains the part number ?
Which column in that sheet contains the part's description ?
A | B | C | |
---|---|---|---|
1 | Part No | Description | |
2 | Part001 | Apple | |
3 | Part002 | Orange | |
4 | Part003 | Pear | |
5 | Part004 | Banana | |
6 | Part005 | Peach | |
7 | Part006 | Grape | |
8 | Part007 | Apricot | |
9 | Part008 | Melon | |
10 |
Sheet: Product |
A | B | C | D | |
---|---|---|---|---|
1 | FORMULA in B2 | |||
2 | Part006 | Grape | =VLOOKUP(A2,Product!A:B,2,0) | |
3 | Part007 | Apricot | ||
4 | Part008 | Melon | ||
5 |
Sheet: Invoice |
If the Part number is selected from dropdown in cell A27, then the formula in B27 should be
=VLOOKUP(A27,Product!A:B,2,0)