Excel 2003 VLookup
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?
|