CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Paul Kra
Paul Kra

Reputation: 3

VLOOKUP is not working is not working and I don't know why

VLOOKUP is not working and I dont't know why and I'm going crazy. Any help appreciated.

Goal:

I have a list with names and postcodes and I want to match them with a second sheet which has the same postcodes but more information about the place!

My Solution:

=VLOOKUP("" & B2 & "",'Targeting Google Ads'!A:B,2,FALSE)

The problem is, as you can see here, it says it did not find the value "1010", when it's clearly there.

Is it a problem that the value I want to get in return is formated like that?

Innere Stadt,Vienna,Austria

Funny thing is, the exact same principle work here and I'm using:

=IFERROR(VLOOKUP(B2,'Alle PLZ in AT'!A:B,2,0),"")

Don't know if that's allowed, but here's the actual sheet to check

I really tried, but now it's just pissing me off that my skills are so mediocre, so any help highly appreciated!

Thank!

Upvotes: 0

Views: 2223

Answers (2)

Mike Steelson
Mike Steelson

Reputation: 15328

Try

=vlookup(to_text(B2),'Alle PLZ in AT'!A:B,2,0)

Upvotes: 1

z..
z..

Reputation: 12993

This is a formatting issue. The values in 'PLZ AT Tabelle' are text, the values in 'Targeting Google Ads' are numbers.

So you should either force the formatting of the second sheet to Plain Text or the formatting of the first sheet to Numbers and remove the concatenations in your VLOOKUP search_key.

Upvotes: 0

Related Questions