|
|
|
|
#1
09-24-2017, 11:56 PM
|
||||
|
||||
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
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
#2
09-25-2017, 01:53 AM
|
|||
|
|||
|
=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:
|
|
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode