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, 05:51 PM

lily

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

Windows 8

Office 2013

Novice

Join Date: Oct 2014

Posts: 18

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

« 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.