vlookup issue 1

Cpreston · Jun 6, 2023

Hi

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.

combo · Jun 6, 2023

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

combo

SkipVought · Jun 6, 2023

... 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.

[tt]
C1: =VLOOKUP(TEXT(A1,"0000"),Data!A:C,3,FALSE)
[/tt]
...COPY N PASTE down.

FYI: faq68-6659

Skip,
_{Just traded in my OLD subtlety...

for a NUance!}
"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!

Cpreston · Jun 7, 2023

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

combo · Jun 7, 2023

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:

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

combo

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

vlookup issue 1

Cpreston

MIS

combo

Technical User

SkipVought

Programmer

Cpreston

MIS

combo

Technical User

Similar threads

Part and Inventory Search

Sponsor