you can use if condition and check the return value if it matches 0 then
show blank
something like ths shuld work
=IF(INDEX(B:B,MATCH(F1,A:A,0))=0,"",INDEX(B:B,MATCH(F1,A:A,0)))
On Wed, Mar 27, 2013 at 8:42 PM, srsev6 wrote:
> I have the following formula that would be working perfectly if
I have the following formula that would be working perfectly if it ignored
blank cells.
The formula I am using is:
=INDEX(Sheet1!$F$2:$F$2250,MATCH(1,IF(Sheet1!$C$2:$C$2250=C4,IF(Sheet1!$D$2:$D$2250=$D$1,0
Unfortunately, if the cell with the result is blank it returns a 1/0/1900.
I wo