Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using text from cell in a range lookup
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using text from cell in a range lookup
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)"&'!A52,"Cell A5 is greater than 2",FALSE) Not knowing exactly what you want to happen, hopefully this helps -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "abergman" wrote: 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using text from cell in a range lookup
Your formula becomes: =VLOOKUP(A1,INDIRECT("'"&A2&"'!$A$23:$D$320"),4,fa lse) The name in cell A2 must be EXACTLY the same as the sheetname for this to work. -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46745 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using text from cell in lookup formula | Excel Worksheet Functions | |||
use cell text in lookup function | Excel Worksheet Functions | |||
Referencing cell text in a lookup | Excel Discussion (Misc queries) | |||
Lookup certain text within a cell, PLEASE HELP! | Excel Worksheet Functions | |||
lookup a text cell and return text | Excel Discussion (Misc queries) |