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-22-2014, 06:17 AM

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

Gebobs, Thank you for your swift response.

What if the list is in another excel document instead of sheet 1.
Is it then also possible to refer to another excel document. Let's name that document List2013.exe

Yes you can.

Would it be possible to attach some samples of the sheets you want to use?

« 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 06:17 PM.