Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 2

Alternative IF Statement

I am trying to simplify this nested IF Statement. It's similar to a LOOKUP
FUNCTION but the data and result is all in a single row. I was unable to get
any LOOKUP statement to work. VLOOKUP OR HLOOKUP.

=IF(A1=2009,B1,IF(C1=2009,D1,IF(E1=2009,F1,IF(G1=2 009,H1,0))))

A B C D E F G H I J
2001 1 2002 3 2009 10 2011 11 2012 12

The answer would be Column F = 10. For "2012" the answer would be 12.

Thanks.

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
alternative to if statement	dan	Excel Worksheet Functions	4	August 15th 06 08:20 PM
If alternative	Busy Bee	Excel Worksheet Functions	4	June 30th 06 12:53 AM
alternative to VLOOKUP	Thierry	Excel Worksheet Functions	2	June 3rd 06 09:48 AM
alternative to msgbox	thephoenix12	Excel Discussion (Misc queries)	36	June 27th 05 09:02 PM
SUMIF Alternative?	qflyer	Excel Worksheet Functions	2	June 20th 05 07:50 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us