T
Theresa
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?
=VLOOKUP(B190,I190:I241,2,FALSE). What am I doing wrong?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Teethless mama
=VLOOKUP(B190,I190:I241,1,FALSE)
G
Gary''s Student
=VLOOKUP(B190,I190:J241,2,FALSE)
G
GTVT06
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?
Is Column C blank in the referenced cell? If so, that's the reason for
the #REF error, there has to be a value in that cell to avoid that
error, or you can add an IF/ISERROR function to your formula
P
Pete_UK
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
third parameter is 2 meaning to return data from the second column.
Make your table wider.
Hope this helps.
Pete
M
muddan madhu
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?
Table array specified for single coulmn, but u r trying to retrieve
the data from column 2 which is not specified in table array.