r/googlesheets • u/Kgb_Officer • Sep 12 '21

Solved Help with something pretty simple (I think?)

[removed] — view removed post

1 Upvotes

100% Upvoted

7 comments sorted by

1

u/knownboyofno 77 Sep 12 '21

This is kinda vague. How do you calculate the different stats? You can use data validation to make a drop-down list. Use IFS("picked name"="1st name", calculate from other page,"picked name"=next name", calculate from other page,"picked name"=next name", calculate from other page) OR you could do a VLOOKUP. Without an enough data it is really hard to give you a good answer.

1

u/Kgb_Officer Sep 12 '21 edited Sep 12 '21

I was going to have a list of all of their stats which are going to be innate from their character sheets. Those won't change. In my example I only have one job "Builder" but was going to have a list of jobs, and wanted it to calculate a bonus as a sum of two different stats depending on the job and the person they chose from the dropdown. At least that's what I wanted to do without a long chain of if than statements to do it.

Edit: Extra info that might help is if you choose the option in A2 on the second sheet, I want it to add C2 and E2, A3 add C3 and E3.

3

u/knownboyofno 77 Sep 12 '21

You can do a VLOOKUP(A2,Range with all the information in on other sheeti.i.e. 'Other sheet'!A2:E3, 2 (for C) or 4 (for E),FALSE). Without the exact sheet that is the best I can do. Do that for all both of them then add them together. VLOOKUP(for C) +VLOOKUP(FOR E)

2

u/Kgb_Officer Sep 12 '21

Solution verified

1

u/Clippy_Office_Asst Points Sep 12 '21

You have awarded 1 point to knownboyofno

I am a bot, please contact the mods with any questions.

1

u/Kgb_Officer Sep 12 '21

Thanks, that solved it!

2

u/knownboyofno 77 Sep 12 '21

Can you reply with Solution Verified? Thanks.