![]() |
|
#1
|
|||
|
|||
|
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....
|
|
|
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 |