how do i assign the contents of a cell to a range name

T

tenswg

Using the vlookup command it would be useful to be able to change the range
name of the data by having it assigned from a cell
 
F

Frank Kabel

Hi
if A1 houses the name of your range try something like:
=VLOOKUP(B1,INDIRECT(A1),2,0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Resource name inside resource sheet: per person, work per hours per week 0
Excel - Wich Function should I use? 1
Pasting a cell into bookmarked table from excel vba 1
How to implement two shifts per day with multiple teams 0
Outlook - Catgorizing emails by names 0
Conditional formatting 2
How can I assign a value to a cell without putting a formula in it 4
Need Help with a VBA subroutine 0

Top