0

I have an issue with vlookup recently when trying to compare 2 tables.

it seems that no matter what i did the end result is always "#N/A"

My goal is to find out the if the overlapping entry in both table via vlookup.

My sample in is this link, can any one help?

http://goo.gl/dvWGm

Many thanks in advance!

Improve this question
2
  • In my IE your content (link) is not shown correctyl. Please check.
    – Trinimon
    Commented May 14, 2013 at 8:56
  • I believe the host does not support IE sorry about that.
    – user2380812
    Commented May 14, 2013 at 8:59

1 Answer 1

Reset to default
0

N/A means that the value in column A is not present in column D, in your case none of the values in column A are present in column D. Try to copy a value from column A and paste it to column D and you'll see that N/A turns into that value.

Improve this answer
2
  • Hi Ari, use data in D and use "find" you will see that there are some that exist in both column.
    – user2380812
    Commented May 14, 2013 at 8:56
  • @user2380812: it's because values on column A have a trailing space character. Just delete the space and it will work
    – Ari
    Commented May 14, 2013 at 9:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.