Thanks for your help!
I use indirect but I can't work it out.
The problem is that I have the shhets in a different worksheet

When I use
=vlookup(A2,INDIRECT("[Libro2.xls]"& B2 &"!$A$1:$B$9"),2,0) It works
Fine

But if the worksheet have spaces in its name I get #!Ref
=Vlookup(A2,INDIRECT("[Libro 2 asd ewq.xls]"& B2 &"!$A$1:$B$9"),2,0)

Thanks




PCLIVE (RemoveThis) ha escrito:

You should be able to use Indirect for that.

=VLOOKUP(A1,INDIRECT(A10 & "!A1:B2"),2)

"A1:B2" represents your lookup table.

HTH,
Paul

wrote in message
ups.com...
Is there a way to change the sheet name in a formula with a name that
is stored in a cell?
I have a vlookup that looks in sheet1 range. I have in the Cell a10 the
name of the sheet I want to lookup the value.

Thanks
Gastón