Lomax

Posts: n/a

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)))

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
isna vlookup	Tim	Excel Discussion (Misc queries)	2	April 3rd 05 11:23 AM
IF ISNA HELP, please..I cant add #N/A but 0 is another story	Sigmaz	Excel Worksheet Functions	2	March 23rd 05 01:23 PM
ISNA and VLOOKUP	Chris Kellock	Excel Worksheet Functions	3	March 12th 05 07:05 AM
if isna and vlookup together	tina	Excel Worksheet Functions	2	January 20th 05 01:06 PM
ISNA question	ShineboxNJ	Excel Worksheet Functions	2	January 6th 05 10:49 PM

All times are GMT +1. The time now is 08:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us