Vlookup - Logical Error

[eralp50]

Hi,

I have been using vlookup quite a while. While I was creating a new formula, I faced with a strange result which I explained at attached excel sheet.
Did I do it wrong?

Thanks,
Eric
.

[Ace_XL]

Change formula to

=VLOOKUP(F4,A1:E14,2,FALSE)

as FALSE returns exact match

[Moo the Dog]

Change your formula from TRUE to FALSE for an exact match:

=VLOOKUP(F4,A1:E14,2,FALSE)

- Moo

[Jonmo1]

More information is needed...
Will F4 ever be a decimal number (not an exact match to one of the values in column A)
If so, what is the expectation, say F4 = 15.5, should the result be LeadDrafter1 or LeadDrafter2?

[Jonmo1]

Double post, sorry.

[eralp50]

Thank you Moo and Ace_xl

[eralp50]

That was really fast. thank you all.

[eralp50]

I have another question related to 'vlookup' formula
this time I lookup a text, but couldn't figure it out which settings should I use? I tried 'text' it didn't work.

20.00 ExpertDrafter3 n/a 522108.00
19.00 ExpertDrafter2 769247.00 572841.00
18.00 ExpertDrafter1 625994.00 437278.00 Formula Gives below data
17.00 LeadDrafter3 473006.00 387822.00 LeadDrafter1 #N/A
16.00 LeadDrafter2 384491.00 278089.00
15.00 LeadDrafter1 325489.00 237696.00 =VLOOKUP(F4,A1:E14,2,TRUE)
14.00 ExpDrafter3 274832.00 185102.00
13.00 ExpDrafter2 225471.00 160912.00
12.00 ExpDrafter1 162169.00 118674.00 It should be 437278.00
11.00 Drafter3 131767.00 89810.00
10.00 Drafter2 117570.00 80487.00
9.00 Drafter1 114451.00 69367.00
8.00 EntryDrafter3 78069.00 58302.00
7.00 EntryDrafter2 108003.00 59751.00

[Tony Valko]

In your sample file which column do you want to get the result from? Column C or column D?

To get the result from column C:

=VLOOKUP(F4,B1:D14,2,0)

To get the result from column D:

=VLOOKUP(F4,B1:D14,3,0)

[eralp50]

Thank you very much

[Tony Valko]

You're welcome!