Thread: ISNA
View Single Post
  #1   Report Post  
Lomax
 
Posts: n/a
Default ISNA

Top of the morning..

I have formula below that gives the "true" when there is no data in the
Table array that is being searched.

Is is possible to have something other than "True" entered into cell D594 --
I would prefer "No data Available". If so could you kindly provide changes
to the below.

Thanks lomax

=(ISNA(VLOOKUP(D594,'OHME IT'!$E$2:$P$2759,12,FALSE)))