Forum Discussion
Solved
Look up table?
I need column B to fill based on the index # in column A. The key to the index is in columns D and E.
In B2:
=XLOOKUP(A2, $D$3:$D$18, $E$3:$E$18, "")
or
=IFERROR(VLOOKUP(A2, $D$3:$E$18, 2, FALSE), "")
Fill down.
In B2:
=XLOOKUP(A2, $D$3:$D$18, $E$3:$E$18, "")
or
=IFERROR(VLOOKUP(A2, $D$3:$E$18, 2, FALSE), "")
Fill down.
- I tried both formulas-I don't have xlookup and the "if error" didn't return an answer.
- I can't thank you enough!!
