CODEWITHSUNDEEP
excelexcel-formulavlookuplookup
Shhhayne
Shhhayne

Reputation: 13

Lookup / Vlookup not returning correct value

Either I use Lookup or Vlookup, the result is wrong if my lookup value is from a formula.

It is correct if I type the lookup value. I'm expecting 5 as result, which I was able to get in first row because I typed '80%'. However in second row, I get 4 when I reference it to the computed 80%: But I need to have it look up via a formula, any help please?

enter image description here

Upvotes: 0

Views: 320

Answers (1)

P.b
P.b

Reputation: 11588

While rounding solved the problem for you, it didn't explain where the problem started.

Judging by your examples matching the correct values when typed and wrong if calculated, I conclude the values in A1:B6 are not percentages, but text strings. Using round on those solves your problem, since round converts the string to a number (if it can).

See explanation in this screenshot: enter image description here

Upvotes: 0

Related Questions