IF statements

R

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
 
K

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
 
R

Rafael Ortiz

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

MRO
 
Top