If Statement with a list item?

[big_fella_andy]

Hey, i'm trying to make a spreadsheet for a game called Travian...

Each troop has different requirements to be created... (Wood,Clay,Iron,Wheat)



So a shortened version of what i'm doing will be...

A list, which looks like...

Legionaire
Pretorian
Imperian

These are given a value of 1 2 3 in the list feature.

Then i will have 4 collumns... Wood,Clay,Iron,Wheat, and i need each one to read a different value (depending on what i choose in the dropdown list)
(for example sakes, the output which the list gives, will go in A17)
The Forumla i tried was....

So, i tried an if statement saying...

=IF(A17="1",1000,IF(A17="2",2000,IF(A17="3",3000)))

Even though A17 reads 1 2 or 3. the value which the if statement is outputting is ALWAYS false. (even if it doesn't show 1 2 3)

Does anyone have an idea what the problem is with this?

Or better still, does anyone know how to make a list. Which will have 1 input (Legionaire) (pretorian etc..) but have the ability to output 4 seperate outputs in 4 seperate cells?


Thanks


Andy

[JBeaucaire]

1) don't put quotes around numbers, that turns them into text.
2) Try this instead:

=A17*1000

or

=LOOKUP(A17, {1,2,3}, {1000,2000,3000})

or

=CHOOSE(A17, 1000, 2000, 3000)

[mewingkitty]

Based on a rough assumption, I think you're attempting to do something like what's in the attached sheet. Let me know if that helps.

mew!

[big_fella_andy]

Thank's for the help you guys, i'll try the second option, seems to have a better visal representation and it "Should" make it easyer for me to manage lol.

Thanks again


Andy

[JBeaucaire]

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].



(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)