VLOOKUP for country / country code

		Microsoft Office Forums > Microsoft Excel > Excel
VLOOKUP for country / country code

FAQ

Thread Tools

Display Modes

09-25-2017, 02:07 AM

mikehk

Windows 10 VLOOKUP for country / country code

Office 2013

Novice

Join Date: Sep 2017

Posts: 15

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Limit min and max number to a cell based on country selection	hussainshaikh1	Excel	1	02-02-2017 07:06 AM
Splitting International Dialing codes into country and area code	stefansfs	Excel	1	08-17-2015 11:49 PM
Skipping USA as a country identifier	Delta223	Mail Merge	1	04-03-2015 02:27 AM
"+" in Country code in Outlook 2010	musicaldoc	Outlook	0	04-27-2013 02:19 AM
Adding a country drop-down list	iyavor	Word	0	10-27-2010 03:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:40 PM.