I'm pretty sure that my equation is correct and if not, I can't work out what I'm doing wrong.

CodePudding user response：

I would advise you to learn how to use Index and Match formulas instead. For this example, it would be =INDEX(A4:B8,MATCH(A5,A4:A8,0),2). Remember to lock the cells if you wish to drag it.

CodePudding user response：

use 4th parameter:

=VLOOKUP(A5, A4:B8, 2, 0)