# VLOOKUP with sheet name as cell reference

1. ## VLOOKUP with sheet name as cell reference

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"

2. ## Re: Help with a Formula Question

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

3. ## Re: Help with a Formula Question

Do you have a small example to show us?

Perhaps take the workbook you are working on, and delete all but the top 7 rows of each sheet.

4. ## Re: Help with a Formula Question

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

5. ## Re: Help with a Formula Question

Here is the sample requested. Please let me know if you need anything else. Thank you again for all of your help!

6. ## Re: Help with a Formula Question

Enter this formula On the MAIN SHEET cell I2 and copy down as needed:

=VLOOKUP(A2,INDIRECT(G2&"!A:V"),15,0)

7. ## Re: VLOOKUP with sheet name as cell reference

THANK YOU!!! That worked perfectly! it is exactly what I needed. Thank you so much

8. ## Re: VLOOKUP with sheet name as cell reference

You're welcome. Thanks for the feedback!

9. ## Re: VLOOKUP with sheet name as cell reference

Hi there, im looking for something like this, is it possible for the vlookup to automatically input a value based on the tab name, ive seen the formula for the one in the sample sheet and that is specific to the sheet name, can it be such where its sheet name A or B or C in one vlooup formula?

10. ## Re: VLOOKUP with sheet name as cell reference

Originally Posted by merQrey
Hi there, im looking for something like this, is it possible for the vlookup to automatically input a value based on the tab name, ive seen the formula for the one in the sample sheet and that is specific to the sheet name, can it be such where its sheet name A or B or C in one vlooup formula?
HI, welcome to the forum

To use a variable sheet name (if I understand, you would need to use INDIRECT.

However, Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

There are currently 1 users browsing this thread. (0 members and 1 guests)