Thread: Formula returning zero
View Single Post
 
Old 12-03-2018, 02:30 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
Since your return values are text, you can also use:

=IFERROR(HLOOKUP(A3,years!A$1:F$5,2,0)&"","")
Reply With Quote