INDEX/MATCH function

[crakter]

Hi!

I'm wondering if someone could help me with a problem i have with INDEX/MATCH function. I am trying to match text in two columns and retreive what is in the third/forth/fifth column.
If you look at the attached file and look in cell B6, B7 and I4->I13 there is the code i'm using to retrieve it. If you look at cell B4 it's a dropdown list with different cities to search for in M/N columns, together with cell B3.
The code I'm using is;

Please Login or Register  to view this content.

This works well with Shanghai, Hong Kong and Seoul but not Xiamen, Beijing and Ho Chi Minh City. Why is it not working with these cities?

[benishiryo]

hi crakter, welcome to the forum & a Merry Christmas to you. N3:N5 has an extra space behind the text "Oslo". remove them & you'll be fine

[crakter]

Hi benishiryo,

Thank you so much. That worked well with both Beijing and Ho Chi Minh City but i can't get Xiamen to get matched it seems. (I added TRIM function to the array, also tried to remove it manually)

Merry Christmas to you too!

[FDibbins]

Xiamen in M3 and A19 both have trailing spaces as well. you need to be more careful entering the data

[crakter]

This is actually apart of a protected workbook so I haven't entered this just copied.
But thank you for checking and helping me!