Help with VLOOKUP Formula

[stkl]

Hi all!

I'm after some help with a VLOOKUP so that I can match data from two tables, and add data from Sheet 1 to Sheet 2 alongside the key (Column 1: ICAO).

This is the formula I've been using which returns the incorrect row of data:

I've attached what I've done so far, it returns some results and they're close, but ultimately not accurate at all. I was wondering if someone may be able to help with my formula so that it returns the correct data? (and where there is no ICAO, ignore the row)

Thank you very much,
Sean

aerodrome-additional-data-v1.xls

[NeedForExcel]

Why do you think it returns incorrect results?

Like, can you tell me a specific row where the data returned is incorrect?

[JohnTopley]

Trailing blanks in ICAO code to mismatch .... use


=IFERROR(VLOOKUP(TRIM($A2),'aerodrome-additional-data-v1.cs'!$A$2:$H$186,6,FALSE),"")

or TRIM the codes!

[stkl]

Thank you very much John, fixed perfectly!

Need to get better at cleaning data, even if it doesn't seem dirty!

[JohnTopley]

Glad to help.