ShineboxNJ

Posts: n/a

ISNA question

Not really sure how ISNA works completely...
here is my formula-
=VLOOKUP((CONCATENATE(C6," ","Average")),TURNS,2,FALSE)

is it-
=(isna(VLOOKUP((CONCATENATE(C6,"
","Average")),TURNS,2,FALSE)),"0",VLOOKUP((CONCATE NATE(C6,"
","Average")),TURNS,2,FALSE))

if its NA i want it to be a 0

Mark

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
Formula Question.....PLEASE PLEASE help!	Anant	Excel Discussion (Misc queries)	4	January 7th 05 09:30 AM
conditional formatting question	chris	Excel Worksheet Functions	2	January 5th 05 03:51 PM
Calculation Question	Lynn Q	Excel Worksheet Functions	4	November 3rd 04 12:14 AM
COUNTIF Question	zbert	Excel Worksheet Functions	1	November 1st 04 01:59 AM
end of worksheet question	olmedic	Excel Worksheet Functions	1	October 29th 04 08:55 PM

All times are GMT +1. The time now is 10:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us