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