Hello

I am using =VLOOKUP($A1,'[DEAL.xls]1'!$A:$J,2,FALSE)

However I am aware that the value I want maybe on sheet called "777" instead
of "1". Is it possible to reference this to a cell or do I need to keep
changing the formula to retreive the col 2 data?

Your help is appreciated. Thanks in advance.