How do I eliminate "false" from showing in a cell?
Thanks.
"JE McGimpsey" wrote:
One way:
=IF(ISNA(MATCH(B9,Q12:Q41,FALSE)),"",VLOOKUP(B9,Q1 2:R41,2,FALSE))
In article ,
thistooshallpass wrote:
Thanks for the response, however, this is the case.
I am using the vlookup formula, =vlookup(B9,Q12:R41,2,"") which produces
"#N/A" when the lookup value cell is blank. So I decided to use an if
formula, =if(B9<0,"0,if(B90,vlookup(B9,Q12:r41,2,0))) thinking that I could
get rid of the #N/A, which I did but inherited 'false' in the cell.
|