#N/A! to be blank please.

[Guest]

Hello from Steved

if no value it is returning a #N/A! please how to I have the cell blank
I know it is iserror but not to shore how to go about putingit in the below
formula.

=VLOOKUP(D6,$U$2:$Y$2000,5,FALSE)

Thankyou

 

[Guest]

Hello from Steved

While waiting I took a look at other posts andf came up with the below.

=IF(ISNA(VLOOKUP(D6,$U$2:$Y$2000,5,FALSE)),"",VLOOKUP(D6,$U$2:$Y$2000,5,FALSE))

Thankyou.