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