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.