Posted to microsoft.public.excel.misc

Scott@CW

external usenet poster

Posts: 62

If statement problem

If the result to the below formula is "0", how can I rewrite this to say "No
Respones"?

=IF(C5="APR07",VLOOKUP(C6,APR07!D16:AB600,4,FALSE) ,IF(C5="MAY07",VLOOKUP(C6,MAY07!D16:AB600,4,FALSE) ,IF(C5="JUN07",VLOOKUP(C6,JUN07!D16:AB600,4,FALSE) ,"No
Data")))

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
problem with IF statement	wolfpack95	Excel Discussion (Misc queries)	1	August 21st 06 08:36 PM
IF statement problem	Ross	Excel Discussion (Misc queries)	6	July 13th 06 04:47 PM
If Statement Problem	Brandy	Excel Discussion (Misc queries)	2	May 3rd 06 04:33 PM
IF STATEMENT PROBLEM	Manjit Gosal	Excel Worksheet Functions	4	November 10th 05 05:40 PM
I have an "IF"Statement problem...please help!!	cmk0007	Excel Worksheet Functions	1	November 5th 04 01:24 AM

All times are GMT +1. The time now is 06:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us