VLOOKUP for country / country code

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

FAQ

Thread Tools

Display Modes

09-25-2017, 01:53 AM

mikehk

Windows 10 VLOOKUP for country / country code

Office 2013

Novice

Join Date: Sep 2017

Posts: 15

=IFERROR.....didn't work.

I tried the Index/Match combination
=INDEX(Sheet2!B15:B37(MATCH(A1,Sheet2!A15:A37,0))

it may work...but I am getting an
error message saying "Your formula is missing a parenthesis--) or (.

Quote:

Originally Posted by Pecoflyer

Try =IFERROR(VLOOKUP(A1,Sheet2!A15:B37,2),"")
Be aware that INDEX/MATCH combination is much more flexible ( and faster on large ranges) than VLOOKUP

« 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.