#1
|
|||
|
|||
VLOOKUP looking at another cell for its range
Hey all,
I was wondering (because I can't find any answers elsewhere) if the following is possible. I would like a VLOOKUP to look at the value/text within another cell to determine which range to look in, i.e. Cell A1 =VLOOKUP(10, (text in A2), 2, FALSE) Cell A2 (text cell) 'Sheet Name'!$B$3:$F$11 Therefore, the final formula should read: =VLOOKUP(10, 'Sheet Name'!$B$3:$F$11, 2, FALSE) Any ideas if this is possible? I am, essentially, just trying to make it so I only have to change one cell and a whole load of different LOOKUP formulae are changed. Thank you for your time, Rich |
#2
|
||||
|
||||
Yes, you can. This is what the INDIRECT function is for. You'd just do it this way:
Code:
=VLOOKUP(10,INDIRECT("'Sheet Name'!$B$3:$F$11"),2,FALSE) |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
trying to use vlookup to calculate several different situations in one cell | heastlund | Excel | 3 | 11-21-2013 12:38 PM |
Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
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 |
Moving formula range multiple cells when moving sum over one cell | FraserKitchell | Excel | 4 | 02-26-2010 10:38 AM |