IF Formula and blank answer
 

Hello this is my formula
=IF(ISNA(VLOOKUP($A4,'PG Disc'!$E$2:$U$632,17,FALSE))," ",VLOOKUP($A4,'PG
Disc'!$E$2:$U$632,17,FALSE)) Here is the thing the column where the answer
goes is formatted as percentage. if column A is blank is till gives me
0.00%. what I want is if column A is blank the answer to be blank (empty
cell) thanks

IF Formula and blank answer
 

One way:

=IF(ISNA(MATCH($A4,'PG Disc'!$E$2:$E$632,FALSE)),"",IF(VLOOKUP($A4,
'PG Disc'!$E$2:$E$632,17,FALSE)="", "", VLOOKUP($A4, 'PG
Disc'!$E$2:$E$632,17,FALSE)))

In article ,
Wanna Learn wrote:

Hello this is my formula
=IF(ISNA(VLOOKUP($A4,'PG Disc'!$E$2:$U$632,17,FALSE))," ",VLOOKUP($A4,'PG
Disc'!$E$2:$U$632,17,FALSE)) Here is the thing the column where the answer
goes is formatted as percentage. if column A is blank is till gives me
0.00%. what I want is if column A is blank the answer to be blank (empty
cell) thanks

IF Formula and blank answer
 

=if(isna(vlookup(...)),"",if(vlookup(...)="","",vl ookup(...)))


Check for an error. Check for empty. Then return the real value.

or

=if(iserror(1/len(vlookup(...)),"",vlookup(...))



Wanna Learn wrote:

Hello this is my formula
=IF(ISNA(VLOOKUP($A4,'PG Disc'!$E$2:$U$632,17,FALSE))," ",VLOOKUP($A4,'PG
Disc'!$E$2:$U$632,17,FALSE)) Here is the thing the column where the answer
goes is formatted as percentage. if column A is blank is till gives me
0.00%. what I want is if column A is blank the answer to be blank (empty
cell) thanks

--

Dave Peterson

IF Formula and blank answer
 

The formula seems to work for me. Did you check your look up data. There
may be true 0% values that you are finding rather that #N/A. Sorry if that
doesn't help.



"Wanna Learn" wrote:

Hello this is my formula
=IF(ISNA(VLOOKUP($A4,'PG Disc'!$E$2:$U$632,17,FALSE))," ",VLOOKUP($A4,'PG
Disc'!$E$2:$U$632,17,FALSE)) Here is the thing the column where the answer
goes is formatted as percentage. if column A is blank is till gives me
0.00%. what I want is if column A is blank the answer to be blank (empty
cell) thanks

IF Formula and blank answer
 

Thanks Dave for Saving the day!

"Dave Peterson" wrote:

=if(isna(vlookup(...)),"",if(vlookup(...)="","",vl ookup(...)))


Check for an error. Check for empty. Then return the real value.

or

=if(iserror(1/len(vlookup(...)),"",vlookup(...))



Wanna Learn wrote:

Hello this is my formula
=IF(ISNA(VLOOKUP($A4,'PG Disc'!$E$2:$U$632,17,FALSE))," ",VLOOKUP($A4,'PG
Disc'!$E$2:$U$632,17,FALSE)) Here is the thing the column where the answer
goes is formatted as percentage. if column A is blank is till gives me
0.00%. what I want is if column A is blank the answer to be blank (empty
cell) thanks

--

Dave Peterson