Hlookup formula help

		Microsoft Office Forums > Microsoft Excel > Excel
Hlookup formula help

FAQ

Thread Tools

Display Modes

11-28-2018, 11:00 AM

ProudLiberal ProudLiberal is offline

Windows 7 64bit Hlookup formula help

Office 2010 64bit

Novice

Join Date: Jun 2017

Location: suburban Chicago

Posts: 28

If I understand your question, this might be your solution:
=IF(ISERROR(HLOOKUP(A2,years!A$1:F$5,2,0))=TRUE,"" ,HLOOKUP(A2,years!A$1:F$5,2,0))

(see attached example)

Attached Files

example revised.xlsx (10.6 KB, 10 views)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:16 PM.