The value of a name

Solved/Closed
Derrall Posts 8 Registration date Thursday April 10, 2014 Status Member Last seen July 1, 2014 - Apr 26, 2014 at 05:18 AM
Derrall Posts 8 Registration date Thursday April 10, 2014 Status Member Last seen July 1, 2014 - Apr 29, 2014 at 12:53 PM
Hello,


I've been playing a lot of dark souls 2, and I'm trying to make a spread sheet to have the value for armor (to start). I plan on making drop downs for the different pieces of armor and when a certain piece is chosen to give values to different cells. For example if Armor A is selected +3 to fire, +3 to physical and so on. This is where the question comes.

Do i use a large if string? if(a2="Armor 2", 300, if(a2="armor 3", 305....) ect

I planned on doing it this way, and hiding the cells, and adding them later down the line

Is there an easier way?

Something along the lines of if(armor 2, (c3+50, c4+40, c5+60)

I do think i use the if command too much, but im used to it from If Then statements, i got used to them, so tell me if i shouldnt even be using it. Thanks in advance, again sorry if this is asked terribly or hard to read.+

2 replies

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
Apr 29, 2014 at 11:00 AM
Hi Derrall,

What you are doing now is putting all your data in formula's.

Normally one would create a database with all the information and then use VLOOKUP formula to retrieve certain information.

Best regards,
Trowa
0
Derrall Posts 8 Registration date Thursday April 10, 2014 Status Member Last seen July 1, 2014
Apr 29, 2014 at 12:53 PM
Thanks for the response, i just watched a couple of videos on vlookup, and ill get to work in seeing how efficient it is.

OR efficient i am with it, lol.
0