Excel 2003 VLookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
First, you can use False or 0 as that 4th argument--same with True or 1.

Second, it sounds like you want to bring back the 2nd column of that lookup
range:
=VLOOKUP(H2,'Information'!A:B,2,0)
(changed range from A:C to A:B and column to be returned from 3 to 2.)

Third, are you sure that the values you see are the exact values. Neither the
value in H2 or in column A is really 61.0000001 and the other 61--that wouldn't
provide a match.

Fourth, look at Debra Dalgleish's site for troubleshooting your =vlookup()
formula:
http://contextures.com/xlFunctions02.html#Trouble
 
Back
Top