IF statements

  • Thread starter Thread starter Richard
  • Start date Start date
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
 
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
 
You should look into using something like VLOOKUP or HLOOKUP to do table
lookups.

MRO
 
Back
Top