Thread: [Solved] Hlookup formula help
View Single Post
 
Old 11-28-2018, 11:00 AM
ProudLiberal's Avatar
ProudLiberal ProudLiberal is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Jun 2017
Location: suburban Chicago
Posts: 28
ProudLiberal is on a distinguished road
Default
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
File Type: xlsx example revised.xlsx (10.6 KB, 10 views)
Reply With Quote