Add VLOOKUP

[Guest]

You are going to kill me, but it keeps returning zero when the total should
be $14.27. Could you take a look at it again.....pretty please?

 

[Pete_UK]

The formula looks fine to me. Check that A14 and B8:B53 contain
compatible values, i.e. if they are meant to be numbers, are you sure
that they are not text values which just look like numbers? If you are
trying to match text values, ensure that you do not have any leading or
trailing spaces.

Hope this helps.

Pete