If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3)

gebobs · #1 10-21-2014, 07:23 PM

Quote:

Originally Posted by lily

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?

lily · #2 10-21-2014, 11:40 PM

Quote:

Originally Posted by gebobs

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

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
show a cell	s7y	Excel Programming	26	05-26-2012 08:00 PM
Word VBA: Cannot Edit Range (Delete characters except the first in a table cell)	tinfanide	Word VBA	3	04-27-2012 09:48 AM
Limit cell range use	talkinglens	Excel	6	12-31-2010 08:43 PM