=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" <[email protected]> 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)))
>
>
Bookmarks