VLOOKUP not finding adjacent columns
 

I am using VLOOKUP - if i set the col_index_num to 1, it shows me the value
it has found, but when i try to increase the number to pull an adjacent
column, I get a #REF!
The data in the adjacent columns is text
any ideas? I searched but couldn't find anything.
thanks
jay

VLOOKUP not finding adjacent columns
 

Jay

It would help to see your VLOOKUP statement.

If you have something like: =VLOOKUP(B1,C:C,1,FALSE) that would be OK

If you have: =VLOOKUP(B1,C:C,2,FALSE) that would fail with #REF!

You would have to change it to: =VLOOKUP(B1,C:D,2,FALSE)

Have a look at the Help for VLOOKUP

Regards

Trevor



"jay" wrote in message
...
I am using VLOOKUP - if i set the col_index_num to 1, it shows me the value
it has found, but when i try to increase the number to pull an adjacent
column, I get a #REF!
The data in the adjacent columns is text
any ideas? I searched but couldn't find anything.
thanks
jay

VLOOKUP not finding adjacent columns
 

What's your formula look like?

Does your table_array consist of more than a single column? If the
column_index_number exceeds the total number of columns in the table_array
you'll get a #REF! error.

Biff

"jay" wrote in message
...
I am using VLOOKUP - if i set the col_index_num to 1, it shows me the value
it has found, but when i try to increase the number to pull an adjacent
column, I get a #REF!
The data in the adjacent columns is text
any ideas? I searched but couldn't find anything.
thanks
jay