View Single Post
 
Old 05-04-2016, 10:43 AM
Marvinapplegate1964 Marvinapplegate1964 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: May 2016
Posts: 1
Marvinapplegate1964 is on a distinguished road
Default 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....
Reply With Quote