Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 05-04-2016, 01:49 PM
gebobs gebobs 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
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

If you have a master list, you can use VLOOKUP.
Reply With Quote
Reply

Thread Tools
Display Modes


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 10:14 PM.


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