VLOOKUP with sheet name as cell reference

**boogyman33** · 03-18-2013, 04:16 PM

Hello everyone,

I am working on an excel workbook that has numerous worksheets. I have an inventory list that I am separating by different vendors. Anyway, I have to link up a buch of rows on the main list using a VLOOKUP formula. however there are more that 10,000 items. so here is what I want. the current formula looks like this:

=VLOOKUP(A8,OHFULTO!$A$7:$V$9,15,FALSE)

I want to know if there is a way that I can substitute the letters in green with a reference that will link to the appropriate page so that I dont have to go an link the items page by page. I have a colum already with the vendor names which matches the worksheet titles. Is there a way or function to keep the VLOOKUP that i need but substitute the green part with the title that I can get from a reference of the "vendor name colunm"

Please help me out guys. thank you!

**Tony Valko** · 03-18-2013, 04:26 PM

Try this...

If cell X1 contains the sheet name OHFULTO...

=VLOOKUP(A8,INDIRECT("'"&X1&"'!A7:V9"),15,0)

EDIT...

On a side note...

You're probably going to get "yelled" at for using an ambiguous thread title. I suggest you change it to something like:

VLOOKUP with sheet name as cell reference

**boogyman33** · 03-19-2013, 08:06 AM

Hey. Thank you so much for the help. I tried doing what you told me but I was not able to do it. It said the function had too many variables. and keeps giving me an error. I will post the sheet soon