Notifications
Clear all
Topic starter
Hi,
attached file
The Data sheet has an invoice number and an invoice amount
In the Vlookup sheet I defined a function to retrieve the invoice amount according to the number.
The problem is that he is unable to extract many cells. I highlighted one line =
the yellow one above which is an example of many other lines.
Thank you for answering and fixing the problem. Leah
Posted : 02/12/2023 3:39 am
I suspect it's a precision issue (the stored value for the yellow cell on the first sheet is actually 427.04999999999995 not 427.05). You could try:
=LOOKUP(2,1/(Data!$A$2:$A$289=A2),Data!$B$2:$B$289)
though that will find the last match, not the first.
Posted : 02/12/2023 4:31 am
Topic starter
Thank you!
It worked on more numbers.
Does this mean that he finds the last match and not the first?
How do you recognize that the number is like this - 427.04999999999995??
I would love to understand the logic in the formula you wrote.
Thank you!!
Posted : 02/12/2023 5:05 am
Yes, it finds the last match if there is more than one.
I looked at the underlying XML for the worksheet.
Posted : 02/12/2023 5:49 am
