#1
|
|||
|
|||
How to have one cell show a value based on the entry of another cell?
I sell 25 different products. Each product has a different price that I purchase it for, and a price that I sell it for. How can I set it up so that whatever 1 item of the 25 items I type into column A, the correct purchase price will show up in column B, and the correct selling price will show up in Column C? I thought I could use the OR function, and include the IF as each item in the OR function, but it only shows TRUE, and not the price.... |
#2
|
|||
|
|||
If you have a master list, you can use VLOOKUP.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need help with using traffic lights in one cell based on date value in a different cell | wmedjaxnjr | Excel | 1 | 04-09-2016 04:22 PM |
Macro to move focus after entry in a cell | Phil H | Excel Programming | 3 | 06-18-2015 01:20 PM |
Restrict Cell Entry | Cardinal2 | Excel Programming | 1 | 01-30-2015 08:01 AM |
Trying to update a table cell with a value based on a drop down box entry | mkasem | Word VBA | 2 | 09-29-2013 08:36 PM |
Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |