#1
|
|||
|
|||
VLOOKUP for country / country code
I tried many formulas and either I get #VALUE or #N/A,
someone please help. =VLOOKUP(A1,Sheet2!A15:B37,2,0) I have in Sheet 2 cell A15 | B15 Australia | 61 Canada | 1 China | 86 |
|
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 |