View Single Post
  #1   Report Post  
Steved
 
Posts: n/a
Default #N/A! to be blank please.

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