Reference Sheet name in a cell?

  • Thread starter Thread starter Nathan Sanders
  • Start date Start date
N

Nathan Sanders

Hi,

I have a cell (A1) that contains a formula which returns a sheet name
depending on some other criteria.

How do I reference that sheet name in a formula in another cell? eg:

=Vlookup(b1,a1!$A:$M,2,false)

Any help appreciated.

thanks

Nathan
 
Hi Nathan,

If I understand your question correctly (apologies if I am wrong) you can
just concatenate the values together like this:

=CONCATENATE(A1,"!",VLOOKUP(B1,<your range>,2,FALSE))

I would suggest using a named range in the <your range> section.

Michael
 
Back
Top