- 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 formula question
Posted on 12/19/12 at 9:28 am
Posted on 12/19/12 at 9:28 am
I want to enter a value in column A and have a corresponding value populate Column B. For instance if I enter "XYZ" in A1, then I want $40 in B1. Or if I enter "ABC" in A1, then I want $50 in B1. How do I do this.
The "IF" function is not doing it for me.
TIA
The "IF" function is not doing it for me.
TIA
Posted on 12/19/12 at 9:45 am to Motorboat
I use Conditional formatting on cells that takes care of the programming for me. Unfortunately, being a technical guy, my excel knowledge is on a novice level.
Posted on 12/19/12 at 9:54 am to Motorboat
Vlookup with a table of abc and xyz sorted alphabetically (descending) with their corresponding values adjacent
Posted on 12/19/12 at 10:01 am to Motorboat
How are "IF" formulas not working for you on this? Are you putting quotation marks around the text you want to see in Column A and also formatting cells in Column A as general?
Posted on 12/19/12 at 10:24 am to Motorboat
=IF(A1="XYZ";40;IF(A1="ABC";50;""))
Format the cells with the formula as currency.
Format the cells with the formula as currency.
This post was edited on 12/19/12 at 10:30 am
Posted on 12/19/12 at 10:29 am to Motorboat
Have you tried using a vertical lookup table?
Or is it just 2 possibilities
Or is it just 2 possibilities
Popular
Back to top
Follow TigerDroppings for LSU Football News