Thread: [Solved] If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3)
View Single Post
 
Old 10-21-2014, 07:23 PM
gebobs gebobs is offline Windows 7 64bit 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