creating a spreadsheet with multiple values needed for multiple scenarios. If the cell beforehand is A then the multiplier should be .1 If the cell is B multiplier is .166 if cell is C multiplier is .3240 if D multiplier is .370 how the hell do I do this?!?!?!?! Thanks
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
not sure where to post this????
- Thread starter Eddie13
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,175
- Office Version
- 365
- Platform
- Windows
Welcome to the Board!
Set up a lookup table, that contains all the possible values are their corresponding multipliers, and then use the VLOOKUP function to look up the right multiplier to use.
See: MS Excel: VLOOKUP Function (WS)
Set up a lookup table, that contains all the possible values are their corresponding multipliers, and then use the VLOOKUP function to look up the right multiplier to use.
See: MS Excel: VLOOKUP Function (WS)
Upvote
0
Similar threads
- Solved
- Question
