I am trying to create a VLOOKUP formula that will differentiate which tab it looks at each time. I have the tabs named according to what is in a certain cell in each row and want the formula to use that cell to choose which tab to look in. So instead of my range for the VLOOKUP beingit would beTab_Name!A1:D4with F2 being the cell that my tab name is stored in. Am I just doing this wrong, or is it even possible? Thanks!'F2'!A1:D4
Last edited by bibleguy125; 11-18-2011 at 06:23 PM.
bibleguy125,
This is a job for the Indirect() formula. Attached is an example workbook based on the sample criteria you stated. Sheet1 contains the formula
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi bibleguy126,
It sounds like you need to use the "Indirect()" function to build a string that then points to what/where you want to do your lookup.
Look at
http://www.handyexceltips.com/2008/0...rect-function/ or
http://dmcritchie.mvps.org/excel/indirect.htm
One test is worth a thousand opinions.
Click the * below to say thanks.
a little different than tigeravatar
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Thanks guys, that's exactly what I needed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks