Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 06-24-2014, 07:56 AM
BobBridges's Avatar
BobBridges BobBridges is offline VLOOKUP looking at another cell for its range Windows 7 64bit VLOOKUP looking at another cell for its range Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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)
(Pause to check for syntax errors....) Yep, I think that's right. The INDIRECT function, as you may have figured out, takes a character string and interprets it as an address or range, which is what you want here. Give it a shot, and let me know if it doesn't work, but I think it's right.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOKUP looking at another cell for its range 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
VLOOKUP looking at another cell for its range Word VBA: Cannot Edit Range (Delete characters except the first in a table cell) tinfanide Word VBA 3 04-27-2012 09:48 AM
VLOOKUP looking at another cell for its range Limit cell range use talkinglens Excel 6 12-31-2010 08:43 PM
VLOOKUP looking at another cell for its range Moving formula range multiple cells when moving sum over one cell FraserKitchell Excel 4 02-26-2010 10:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft