Excel 2000 question

[JPS]

Ok, I'm trying to figure out how to make the cell recognize a variable in a cell and call a value from another page depending on the #

Example

if c1="1" then c4=sheet2!d3
if c1="2" then c4=sheet3!d3
if c1="3" then c4=sheet4!d3

anyone know I can accomplish this? I need all the coding in sheet1!c4

edit to add: I also ned to know if its possible to call a cell value that is user inputed

Example: I have the experience tables on sheet2, sheet 3, and sheet 4 for slow/average/and fast values respectively, when a user puts 34 as a level on sheet one I'd like it to read from row 34 on sheet 2, 3, or 4 depending on what they put as the level up rate(this can be linked to my first question)

I know its a lot to ask, I know quite a bit on excel but not how to manipulate logic commands yet

[thetruecoolness]

Re: Excel 2000 question

Look up the IF function in the help. does what you want (you'll have to nest them for multiple paths). And when you link to a cell it doesn't matter if it has a formula in it or a value.

I guess that's what you're asking.

[JPS]

Re: Excel 2000 question

ohh ok I get it, I didn't know you could nest multiple commands in the same cell.

durrrr

Thanks TCC

EDIT: How do you create a If statement? Help does nothing for me Itd be nice if they gave me an example, but nope, they explain it and I dont get it