Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

vlookup issue

vlookup issue

vlookup issue


I have a sheet with a vlookup which I cannot get to work. In the Vlookup tab column C I want it to bring the information in the data tab column c where column A in both sheets match.

But I am getting #N/A for all of the results. I have googled how to the vlookup so I think I have it right but could be wrong of course.

I have attached an example of the sheet

Thanks in advance for any assistance.

RE: vlookup issue

Col. 1 in Data sheet contains text with apostrophe as first character, so no match.


RE: vlookup issue

... and since your workbook has a data mismatch, you can compensate by converting your lookup value from a number to a string of 4 digits.

C1: =VLOOKUP(TEXT(A1,"0000"),Data!A:C,3,FALSE)

...COPY N PASTE down.

FYI: FAQ68-6659: When is a NUMBER not a NUMBER?


glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

RE: vlookup issue

Ouch how stupid of me I didnt notice the Data sheet contains text with apostrophe and also thanks Skip the =VLOOKUP(TEXT(A1,"0000"),Data!A:C,3,FALSE) worked perfect.

Thanks as always

RE: vlookup issue

For such cases I have procedure that edits cells and assigns the same formulas. If cells are not formatted as text, numbers as text are converted to numbers. It can be applied to values in col. A, 'Data' sheet. The macro converts selected range:

Sub ReEnterFormula()
Dim c As Range
For Each c In Selection
    With c
        .Formula = .Formula
    End With
Next c
End Sub 


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close