vlookup
Your lookup table is only one column wide, i.e. I190:I241, but your
third parameter is 2 meaning to return data from the second column.
Make your table wider.
Hope this helps.
Pete
On Mar 19, 5:11*pm, Theresa wrote:
Hi, I am trying to create a formula and I get #REF in return. *The formula is
=VLOOKUP(B190,I190:I241,2,FALSE). *What am I doing wrong?
|