Formula Excel 2003

C

coolit47

=IF($A$2=1,AC19,IF($A$2=2,AD19,IF($A$2=3,AE19,IF($A$2=4,AF19,IF($A$2=5,AG19,IF($A$2=6,AH19,IF($A$2=7,AI19,IF($A$2=8,AJ19))))))))

Is there an easier way to set up this formula that pulls Budgeted dollars
from Excel and for reporting.

Thanks
 
A

Anu

Using Hlookup will be an easier option. Create a table with Rowl 1 as
1,2,3....Create Row2 with references ie=Ac19 and drag it horizontally.

Regards
Anu
 
Top