vlookup

[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?

 

[Teethless mama]

=VLOOKUP(B190,I190:I241,1,FALSE)

 

[Gary''s Student]

=VLOOKUP(B190,I190:J241,2,FALSE)

 

[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

 

[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

 

[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.