Hi Ben,

=VLOOKUP(A18, [Sheet2]T01!A8:B731,2,FALSE)

There isn't a second column in the range A8:A731....
--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Ben" wrote in message ...
| Hello all,
|
| I am currently vlookup'ing information off another document and have run
| into problems.
|
| My vlookup statment...
|
| =VLOOKUP(A18, [Sheet2]T01!A8:A731,1,FALSE)
|
| Now, that statment works Brilliantly. However, when i change the colum range
| to '2', e.g...
|
| =VLOOKUP(A18, [Sheet2]T01!A8:A731,2,FALSE)
|
| ... i get all sorts of problems... mainly, "#REF!"
|
| I do not have a clue as to why this is the case as i just want the info from
| that particualr colum.
|
| Help and Thanks!