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!!
You're welcome!
- No idea how I was messing it up, but when I cut and pasted yours, it worked perfectly. Thank you much! I was afraid I was going to have to match 2,000 cells by hand!.