|
|
#5
11-29-2018, 12:25 AM
|
||||
|
||||
As you seem to be using a post 2003 version, a shorter function is available
=IFERROR(HLOOKUP(A2,years!A$1:F$5,2,0),0)
__________________
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 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 HLookup Formula
|
monisankar | Excel | 2 | 12-12-2016 06:18 AM |
| Indirect with hlookup | jamesjts | Excel | 3 | 01-05-2016 09:13 AM |
|
Vlookup/hlookup
|
Ntema | Excel | 4 | 10-14-2013 08:49 AM |
|
HLOOKUP, if,? OR MACRO
|
bobbyarnold | Excel | 22 | 01-14-2013 08:44 AM |
| HLOOKUP with VLOOKUP into different Doc | freeman | Excel | 0 | 09-18-2012 02:04 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode