VLOOKUP for country / country code

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

FAQ

Thread Tools

Display Modes

09-24-2017, 11:51 PM

mikehk

Windows 10 VLOOKUP for country / country code

Office 2013

Novice

Join Date: Sep 2017

Posts: 15

Thanks for your quick reply.

I got it working with
=VLOOKUP(A1,Sheet2!A15:B37,2)

The formula works fine, except when the lookup cell is
empty, I get #N/A. I believe it can show an empty cell
with ISBLANK...what should be the code?
I tried =IF(ISBLANK(=VLOOKUP(A1,Sheet2!A15:B37,2)) but
doesn't work.

« 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:05 PM.