Using text from cell in a range lookup

A

abergman

I'm doing a vlookup across multiple tabs and I have one summary sheet.
All of the lookup values are listed on the summary tab along with their tab
designation (ie A1 = Doe, John, A2 = MW Region).
Would it be possible to do a vlookup in this summary tab using these
references? For example, would it be possible to do vlookup(A1,
A2!$A$23:$D$320,4,false)
I want to be able to have the vlookup search in the right tab without having
to change the formula for each section.
Thank you!
 
L

Luke M

You're going to need to nest your formula with INDIRECT
You could use the VLOOKUP to get the Sheet name, and then plug that into the
INDIRECT command.
Example of nested formula
=IF(INDIRECT("'"&VLOOKUP(A1,
A2!$A$23:$D$320,4,false)"&'!A5>2,"Cell A5 is greater than 2",FALSE)

Not knowing exactly what you want to happen, hopefully this helps
 

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

create a formula by using text from other cells 1
Vlookup from a formula field 6
vlookup 1
Referencing a tab in a formula 2
Automating references to tabs in formulas 4
Referring to a cell by using another cell for the row number 6
Vlookup and Trace Return Cell 2
how do i use the text in a cell as a named range in a vlookup form 2

Top