Hello
The last argument in your formula is not valid.
In VLOOKUP, the last argument is boolean (either TRUE or FALSE).
Refer to help for additional information on VLOOKUP function.

If you amend your formula with:
=VLOOKUP(H2,'Information'!A:C,3,FALSE)
It should return the correct value.

HTH
Cordially
Pascal

"Ran-off" a écrit dans le message de
news: ...
I want to create a formula to help in a spreedsheet I created. I want to
have Cell J2
fill in with information that is obtained from two places. Let me explain.
in cell H2 is a number 61 (in all of the H columns there are numbers from
61
to 69). I have another spreadsheet (connected to this main spreadsheet,
i.e.
another tab) on this spread sheet I have in Column A2 the number 61 (in
column A3 62 etc) in Column B2 I have the word Direct (in Column B3 I have
another word etc) Each of these words signifies what the number means.
(some of these words overlap- but thats ok) I want to have column J2 fill
with, not the info from H2, but what word corresponds with that
information.
I have been using =VLOOKUP(H2,'Information'!A:C,3,0) but it does not seem
to
pull up the right information. Any Help?