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....
|