Vlookup/Indirect Address Question

[deriv3]

Hello,

I have a quick question.

So I have three inputs into a formula. In Sheet1, The values in cells A1, B1, and C1.. I want to output to cell D1

Somewhere in column A of sheet 2 is the value of A1 (to be looked up). Once this value is found, i want the cell next to it or two spaces next to it depending on the value in B1 (of sheet1)

The value in cell C1 contains the name of the sheet to lookup a value in. Using Vlookup, this is a pretty straightforward question except that the sheet is not manually chosen. It is dependent on the value in C1 (C1 is the name of the sheet as a string).

What it comes down to, when typing in something like Sheet1!A1:E1.. how do I replace "Sheet1" with a variable string? How can I do this?

Thank you so much for your help!

[Domenic]

Try something like this...

=VLOOKUP(A1,INDIRECT("'"&C1&"'!A1:E100"),B1,0)

Hope this helps!

Hello,

I have a quick question.

So I have three inputs into a formula. In Sheet1, The values in cells A1, B1, and C1.. I want to output to cell D1

Somewhere in column A of sheet 2 is the value of A1 (to be looked up). Once this value is found, i want the cell next to it or two spaces next to it depending on the value in B1 (of sheet1)

The value in cell C1 contains the name of the sheet to lookup a value in. Using Vlookup, this is a pretty straightforward question except that the sheet is not manually chosen. It is dependent on the value in C1 (C1 is the name of the sheet as a string).

What it comes down to, when typing in something like Sheet1!A1:E1.. how do I replace "Sheet1" with a variable string? How can I do this?

Thank you so much for your help!

[Harlan Grove]

deriv3 wrote...
....
>Somewhere in column A of sheet 2 is the value of A1 (to be looked up).
>Once this value is found, i want the cell next to it or two spaces next
>to it depending on the value in B1 (of sheet1)
>
>The value in cell C1 contains the name of the sheet to lookup a value
>in. Using Vlookup, this is a pretty straightforward question except
>that the sheet is not manually chosen. It is dependent on the value in
>C1 (C1 is the name of the sheet as a string).
....

=VLOOKUP(A1,INDIRECT("'"&C1&"'!A:C"),B1,0)