Forum Discussion
Excel
I have a list of food that the user will select from a drop down list. each food has a value. Based on the selection I want another cell to print this value. For example: Cell A1: A10 has names of...
In E1:
=IFERROR(VLOOKUP(D1,$A$1:$C$10,2,FALSE),"")
In F1:
=IFERROR(VLOOKUP(D1,$A$1:$C$10,3,FALSE),"")
If you have Microsoft 365 or Office 2021, you can enter this formula in E1. It will automatically spill to F1:
=XLOOKUP(D1,$A$1:$A$10,$B$1:$C$10,"")
All these formulas can be filled down if required.