IF statements

[Richard]

I am trying to produce an IF statement that will pick a
value from a table if it fits certain criteria. Im trying
to produce a cashflow sheet, that will pick a certain
value depending on the month it is in.

Has anyone done something similar? and do they have a
formula I could use?
Thanks

 

[Kevin Stecyk]

Richard,

Not knowing exactly what you are attempting, I think you are looking at a
"lookup" function. Check out hlookup, vlookup in Excel's documentation.

Hope that helps. If not, please provide more description.

Kevin

 

[Rafael Ortiz]

You should look into using something like VLOOKUP or HLOOKUP to do table
lookups.

MRO