Using VLOOKUP with multiple sheets with flexible sheet names

Hello,

I have a master worksheet, which needs to fetch the last values of a column from another sheet (in the same workbook).

My special requirement is that the sheet names are given in Column A in the master Worksheet, and the VLOOKUP formula should get the sheet names from that column.

This is because the master "Worksheet" is permanent, but the other sheets gets added removed occasionally.

Attached is the sample file.

Thanks for any help!

The example numbers that you show in sheets AD and EH are all sorted in increasing order, so the last number in column B on both sheets is also the largest number. Is this always the case? If so, you could use MAX to find the last number, or you could use LOOKUP, as in these two examples:

=MAX(INDIRECT("'"&A2&"'!B1:B100"))

=LOOKUP(9999,INDIRECT("'"&A2&"'!B1:B100"))

Hope this helps.

Pete

Wow, that was an insanely fast reply. Thank you so much, Richard. This seems to do what I need. Cheers!

No Pete, not always the case. Thanks for the reply anyways. Cheers!

Well, the second one will give you what you want.

Pete