Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-04-2016, 10:43 AM
Marvinapplegate1964 Marvinapplegate1964 is offline How to have one cell show a value based on the entry of another cell? Windows 7 64bit How to have one cell show a value based on the entry of another cell? Office 2010 64bit
Novice
How to have one cell show a value based on the entry of another cell?
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to have one cell show a value based on the entry of another cell? 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
How to have one cell show a value based on the entry of another cell? Macro to move focus after entry in a cell Phil H Excel Programming 3 06-18-2015 01:20 PM
How to have one cell show a value based on the entry of another cell? Restrict Cell Entry Cardinal2 Excel Programming 1 01-30-2015 08:01 AM
How to have one cell show a value based on the entry of another cell? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft