#1
|
|||
|
|||
Formula returning zero
Could someone help me, I have hlookup formula returning value 0 if in sheet years in no value.
Thank in advanced |
#2
|
||||
|
||||
Your formula does not return an error when the cell is empty, it is the same as 0
Perhaps like this ? =IFERROR(IF((HLOOKUP(A2,years!A$1:F$5,2,0))=0,"",H LOOKUP(A2,years!A$1:F$5,2;0)),"") ( the space between H and LOOKUP is added by the board. Disregard it)
__________________
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 |
#3
|
||||
|
||||
Since your return values are text, you can also use:
=IFERROR(HLOOKUP(A3,years!A$1:F$5,2,0)&"","") |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Hard Returning | Phil H | Excel | 2 | 05-15-2018 03:29 AM |
Hyperlink formula returning 'invalid site address' | MarkH | Excel | 0 | 12-26-2015 10:43 AM |
Returning a whole row | kevskisa | Excel | 2 | 07-28-2015 03:19 AM |
COUNTIFS returning Value Error | ubns | Excel | 1 | 04-16-2015 02:00 PM |
Returning Next Record to the top | bordercollie10 | Mail Merge | 0 | 02-26-2009 09:06 AM |