Microsoft Office Forums - View Single Post - [Solved] VLOOKUP for country / country code

Thread: [Solved] VLOOKUP for country / country code

View Single Post

Old

09-25-2017, 02:07 AM

mikehk

mikehk is offline

mikehk uses Windows 10

Windows 10 mikehk uses Office 2013

mikehk uses Office 2013

Office 2013

Novice

The original poster

Join Date: Sep 2017

Posts: 15

mikehk is on a distinguished road

Default

Problem solved !

here's the formula :

=IFERROR(INDEX(Sheet2!$B$15:B44,1*(MATCH(Sheet2!A1,Labels!$A$15:$A$37,0))),"")

1* was missing from your formula.

Thank you so much

Reply With Quote