- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel Gurus
Posted on 6/30/15 at 2:23 pm
Posted on 6/30/15 at 2:23 pm
Okay gurus...using the two tables A1:B5 and A7:E13, how can I validate the converted amounts in E16:E21? Ultimately, I need to have formulas in K16:K21 that validate E16:E21. I tried a variety of vlookups and index match formulas to no avail. Any help is appreciated.
Posted on 6/30/15 at 3:00 pm to Big Chipper
Is E16:E21 a formula or is someone typing in a constant?
Posted on 6/30/15 at 3:06 pm to CubsFanBudMan
It's supposed to be calculated based on the above. It's incorrect.
Posted on 6/30/15 at 3:33 pm to Big Chipper
What do you mean validate?
Posted on 6/30/15 at 3:45 pm to Big Chipper
I think you need to nest some vlookups. In K16 try:
=J16*vlookup(vlookup(H16,$B$8:$E$13,4,False),$A$2:$B$5,2,False)
=J16*vlookup(vlookup(H16,$B$8:$E$13,4,False),$A$2:$B$5,2,False)
Posted on 6/30/15 at 3:49 pm to Big Chipper
Click on help in Excel and type in data validation. It will give you step by step on how to do a copy data validation into another cell.
Maybe that will help you.
Maybe that will help you.
Posted on 7/1/15 at 10:57 am to Big Chipper
What exactly are you trying to do? Is this a made up representative scenario, or real?
Your entire table of A16:E21 is a copy from A8:A13, with one extra column for "Converted Amount". This converted amount can be done with just a formula using a vlookup to find the conversion rate. No validation required.
Your entire table of A16:E21 is a copy from A8:A13, with one extra column for "Converted Amount". This converted amount can be done with just a formula using a vlookup to find the conversion rate. No validation required.
Back to top
Follow TigerDroppings for LSU Football News