0

The name "Dodson" is on A5, the lookup is from B5, the table A16:B19, the value in the second column of the table, but am looking for the precise result of a VLOOKUP.

The formula I have is:

=VLOOKUP($B5,$A$16:$B$19,2,FALSE)

students:

A        B       C
========================
Dodson  Silver  400
Jones   Gold    550
Clarke  Titanium    700
Ranger  Platinum    750
McKinley    Platinum    750
Broadnax    Gold    550
Burch   Titanium    700

price:

Silver   400.00 
Gold     550.00 
Titanium     700.00 
Platinum     750.00

Trying to get an exact match using relative and absolute cell references.

And then copied into other cells.

Not too sure about the true/false usage here, as I get odd results with “true” which should be exact.

Not looking to use XLOOKUP or other functions.
Improve this question
3
  • 1
    Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.
    – Community Bot
    Commented Mar 21 at 21:00
  • When setting the 4th parameter in VLookup, ask yourself "do you want misleading and confusing results?" - and then user TRUE or FALSE accordingly. For an exact match, you always specify the 4th parameter and you would always use FALSE (or 0).
    – teylyn
    Commented Mar 21 at 22:22
  • thank you for all the comments, and it makes more sense now.
    – Nick
    Commented Mar 21 at 22:49

1 Answer 1

Reset to default
0

The formula you posted creates the result you describe. For an exact match, the 4th parameter of the Vlookup must be FALSE The formula was entered in cell C5 and copied down.

=VLOOKUP($B5,$A$16:$B$19,2,FALSE)

enter image description here

Improve this answer
2
  • If that resolved your issue, please mark the answer as described in the tour. If it didn't, please leave a comment, so I can follow up.
    – teylyn
    Commented Mar 21 at 22:28
  • that's excellent, and thank you.
    – Nick
    Commented Mar 21 at 22:49

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .