Thread: Vlookup Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ben Ben is offline
external usenet poster
 
Posts: 509
Default Vlookup Help

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!