V Look Up Formula Not Working

J

Jwelker12

New member
Joined
Jul 17, 2015
Messages
2
Reaction score
0
Points
0
View attachment Workbook2.xlsx

Hello,

I am having trouble getting my V Look up formula to work when the amounts are the same but when the numbers are not part of a formula the V Look up formula works. I wasn't able to figure it out and i was hoping someone might be able to figure out why it is not working.

I have attached the document to this thread so you can take a look at it.

Please let me know if anyone has any questions.

Thank you,

Jwelk
 
Jwelker12 said:
View attachment 3728Please let me know if anyone has any questions.
Click to expand...
VLOOKUP returns the error if "lookup_value" does not exist
In cell A21 there is the number 1, the number 1 does not exist in "table_array"

In cell A15 you have the result of a formula 1.95107913669065
In cell B15 you have the result of a formula 1.95107913669065

In cells E15 and cell F15 you have the number 1.951079137
 
Last edited:
Ranking Error

Helo Navic,

The main issue I'm having is why A17 & A18 are not showing the same ranking as E17 & E18 because if they calculated the same then I would not have the errors in B21 & C21.

It doesnt make sense to me why E17 & E18 would work but A17 & A18 would not work when they are the same numbers?

Any ideas?

Thanks

Jwelk
 
You must log in or register to reply here.
Back
Top