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