Home
Forums
New posts
Search forums
Articles
Latest reviews
Search resources
Members
Current visitors
Newsgroups
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
Computing
Microsoft Office
Excel Vlookup formula based on cell data
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
[QUOTE="Becky, post: 14253010, member: 3225"] It doesn't matter whether the data ranges are the same, unfortunately you will have to name each one... That is, select the range, and assign a name to it by typing it in the name box. So it might take a while to set up, but I think it could work. For example, if you gave the range B2:C519 on worksheet 2301 the name Tank_2301, and had Tank_2301 as text in (say) cell A1, then your formula could be: =VLOOKUP($B$3,INDIRECT(A1),2) Then the formula would be referring to the range B2:C519 on worksheet 2301. Likewise, when the named range in A1 changes, the range referred to in the formula would change. I think. In theory. Give it a try and let me know if it works! [/QUOTE]
Verification
Post reply
Home
Forums
Computing
Microsoft Office
Excel Vlookup formula based on cell data
Top
