How do I change the underlying value of the cell? Both of them show up as
number with format "General" and I tried to change format to "number" and it
didn't help- as you prdicted.

The formula is pretty simple

= vlookup(A2, lookuptable $A2, B35, 2, false)



"Pete_UK" wrote:

It might be that the lookup value is actually text and the lookup
vector is made up of numbers, or vice-versa. Formatting does not
affect the underlying value in the cell. Post your formula and then I
could advise how you might trap both of these situations.

Pete

On Dec 12, 10:30 am, yhoy wrote:
It seems to be an easy task however I keep getting #N/A-- I have checked so
far:

- the "table array" is sorted
- both "look up value" and the "table array" have format "General"
- lookup value is in the "table array"

what can possibly go wrong? any help is appreciated