![]() |
|
#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 |