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

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

FAQ

Thread Tools

Display Modes

10-21-2014, 07:23 PM

gebobs

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

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?

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:29 PM.