Using function results as parameters in another function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the VLOOKUP function and it works as described. However, I would
like to use it in the following way:
Let's say that I have some text in A1, and it will change from time to time.
I need to do a VLOOKUP, where the text in A1 will determine the named range
that the VLOOKUP will be perfomed on.

For example, if A1 contains "Steve" then I would like to have the VLOOKUP
performed on a range named "SteveScores", or if A1 contains "Mike", then I
would like to do the lookup on a range named "MikeScores".

I know that I need to CONCATENATE the text in A1 with "Scores" but I cannot
figure out how to get the VLOOKUP function to accept that concatenated text
as the parameter for the named range to do the loopup in.

Is this even possibe?
 
You must log in or register to reply here.

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

Help With VLOOKUP 2
Using Value of a Cell in the Range Reference in VLOOKUP 1
Store formulas in Vlookups? (another try ;) 6
Avoiding redundant calculations 7
Vlookup and return sheet name also 2
How do I reference a "range" for a specific table_array in VLOOKUP 3
Vlookup 1
VLOOKUP using Fifth Column 3

Back
Top