Thank you.

I am trying to get the exact value and if there is no match, return #N/A.

The problem I have is that when I use the lookup
=VLOOKUP(R617;table2;2;false), even if there is an exact match, the formula
returns #N/A.

Could the formatting be the problem ?

"Pete_UK" wrote:

but the value returned is 9999 and 440.43 respectively.

This is what you would expect to be returned - in the second case you
have the value in your table, so 440.43 is returned. In the first case,
the value is not found, but you are not looking for an exact value -
instead, Excel returns the value corresponding to the largest item in
the table which is less than the lookup value, so you get 9999.

What suggestions are you hoping for?

Pete