Alright, so first off I'll address issue #1: Index Lookup.

I have a bunch of Values I'd like to convert from one page of the same document(Page 2 to Page 1), from the following format: A31: Swordmaster, B31: -.05, C31: 0, D31: 0, E31: .05, F31: 0, G31: .05, H31: -.05, I31: 0, to be placed on page 1 as such: G4: -.05, G5: 0, G6: 0, G7: .05, G8: 0, G9: .05, G10: -.05, G11: 0, G12: Swordmaster

What would be preferred, is to create something through VB to create a menu for G12 to select the presets like row 31 on page 2, to row 52 on page 2, and input the values from Horizontal lookup to Vertical lookup or whatever it is. Just need to figure out how this is done.

Issue #2 is more complicated, by a lot.

I need to create a saved value somehow that only calculates once per input value, but will change over time as I change the value I input. Here is the current setup:

A3-I/J3: Stat, Growth Points Earned, Exp Gained, Growth Rate, Weapon Change, Item Change, Enemy Change, Current Growth Points, Starting Growth Points, Growth Points

How this Formulae currently works: Exp Gained=D14(B14-C14). B4=C4*(D4+E4+F4+G4)
Also can be read as: Growth Points Earned=Exp Gained*(Growth Rate+Weapon Change+Item Change+Enemy Change).

What I would like to have this formulae do:

Take the Exp Earned Value, autocalculate the Growth Points Earned, and add them with Growth Points to create a value for Current Growth Points, at which point, Current Growth Points converts its value into Growth Points, so that it is ready for the next exp gained input value.

Again, this will probably have to be done somehow through VB, in which I will require help figuring out.

While Issue #2 is the main reason I have come looking on here, it is something I COULD live without, but would prefer not to, as it saves a ton of time for myself instead of taking time.
Issue #1 seems easy enough and I could probably figure it out on my own, but since I don't have much time to actually play around with the spreadsheet all the time, I'd like some guidance in the right direction.