vlookup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Theresa - 19 Mar 2008 18:11 GMT

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?

Reply to this Message

Teethless mama - 19 Mar 2008 18:23 GMT

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

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

Reply to this Message

Gary''s Student - 19 Mar 2008 18:24 GMT

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

Signature

Gary''s Student - gsnu200774

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

Reply to this Message

GTVT06 - 24 Mar 2008 20:14 GMT

On Mar 19, 12:11 pm, Theresa <Ther...@discussions.microsoft.com>
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?

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

Reply to this Message

Pete_UK - 24 Mar 2008 20:21 GMT

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

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

Reply to this Message

muddan madhu - 25 Mar 2008 04:18 GMT

On Mar 19, 10:11 pm, Theresa <Ther...@discussions.microsoft.com>
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?

Table array specified for single coulmn, but u r trying to retrieve
the data from column 2 which is not specified in table array.

Reply to this Message