VLOOKUP for country / country code

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

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 05:52 AM.