Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-21-2014, 05:55 PM
lily lily is offline If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3) Windows 8 If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3) Office 2013
Novice
If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3)
 
Join Date: Oct 2014
Posts: 18
lily is on a distinguished road
Default

Oh, it isn't only just one watch to look for.


Depending on the item to look for, find the matching description and price.
Reply With Quote
  #2  
Old 10-21-2014, 07:23 PM
gebobs gebobs is offline If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3) Windows 7 64bit If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3) Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Quote:
Originally Posted by lily View Post
Oh, it isn't only just one watch to look for.
Depending on the item to look for, find the matching description and price.
If there is more than one, how should we know what to look for? We need a primary key...one that defines the record definitively.

If watch isn't enough, then what? Watch #3? Watch #2?
Reply With Quote
  #3  
Old 10-21-2014, 11:40 PM
lily lily is offline If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3) Windows 8 If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3) Office 2013
Novice
If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3)
 
Join Date: Oct 2014
Posts: 18
lily is on a distinguished road
Default

Quote:
Originally Posted by gebobs View Post
If there is more than one, how should we know what to look for? We need a primary key...one that defines the record definitively.

If watch isn't enough, then what? Watch #3? Watch #2?
yeah, like for example

Watch Description Price
Armani Armani, blue rubber wrist HK$5,000,000
Armani Gold Armani, gold wrist HK$198,000
Cartier Cartier Jewellery wrist watch HK$248,000

and the list goes on and on.

so, there is actually a list of watches, with the matching description and price
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOKUP looking at another cell for its range Rich18144 Excel 1 06-24-2014 07:56 AM
Change formula cell range based on cell value Scoth Excel 4 10-25-2012 07:51 AM
If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3) show a cell s7y Excel Programming 26 05-26-2012 08:00 PM
If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3) Word VBA: Cannot Edit Range (Delete characters except the first in a table cell) tinfanide Word VBA 3 04-27-2012 09:48 AM
If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3) Limit cell range use talkinglens Excel 6 12-31-2010 08:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:21 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