a further clarification, can you name a range of cells say A1:K22 game, and
then specify sheet1!game, sheet2!game without haveing to name then on sheet1
and sthhet2 and sheet3...?

"Bob Phillips" wrote in message
...
Yes. Select sheet1,

InsertNameDefine...

then in the 'Names in workbook' put Sheet1!game, then add the range in the
Refersto box.

Repeat for sheet2, etc.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
...
Can you have sheet specific named ranges?

ie
sheet1!game, sheet2!game, sheet3!game


so they can be referenced in a lookup, pulling values from the correct
sheet.

thanks