Vlookup different sheets

[davi65]

I need help with a Vlookup. I have a file with 30 sheets and every sheet have a different name but they are all same format.

I want to create a main sheet to get the value of F3 and F4 . My main sheet will have Collum A with the names of all the sheets and Collum B and C I want to get the value of F3 and F4

[Tony Valko]

Try this...

Assume the sheet names start in cell A2.

Enter this formula in B2:

=INDIRECT("'"&A2&"'!F3")

Enter this formula in C2:

=INDIRECT("'"&A2&"'!F4")

Select B2:C2 and copy down as needed.

[davi65]

Try this...

Assume the sheet names start in cell A2.

Enter this formula in B2:

=INDIRECT("'"&A2&"'!F3")

Enter this formula in C2:

=INDIRECT("'"&A2&"'!F4")

Select B2:C2 and copy down as needed.

Perfect Thanks

[Tony Valko]

You're welcome. Thanks for the feedback!