=IF(ISNA(VLOOKUP(D594,'OHME IT'!$E$2:$P$2759,12,FALSE)),"No data
available",VLOOKUP(D594,'OHME IT'!$E$2:$P$2759,12,FALSE))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Lomax" wrote in message
news:TxNEe.47887$up5.19939@lakeread02...
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)))