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.