vlookup with variable name

[yaju1120]

Hi all,

I'm trying to do a vlookup inside of a FOR Loop where the lookup value is the name of a sheet, which I've made into a variable. When the next count of the FOR Loop changes, so does the sheet name.

The formula gives me an error as the lookup value requires the sheet name to be in quotations in order for it to return a value. I've tried every possible combination without any success. Below, I've inserted the code

Please Login or Register  to view this content.

Thanks in advance for any help you can provide.
J.

[DonkeyOte]

When using quotations literally you need to double up (or use Chr 34)

Please Login or Register  to view this content.

[Leith Ross]

Hello yaju1120,

Assuming SName is a string, you can add the quotes like this:

Please Login or Register  to view this content.

[yaju1120]

DonkeyOte & Leith,

You guys are awesome...I kept on trying to double up the quotations but using different syntax and it wouldn't work.

Your code works to perfection!!!

Thanks a bunch...
J.