Hi James,

James Michael wrote:
I have a table that has a set of values (formated MMM123) and their
corresponding numbers(formated 123). I would like to reference data
from the corresponing sheet number(sheetname='123') based on the the
original value(MMM123). What this would all do is when looking up a
cell in another sheet(VIEWDATA) it would check the table to find
which number sheet('123') and then display data found in in a cell on
that sheet. What would be the best way to go about doing this?

I'm not exactly clear on what you're trying to do. But take a look at the
INDIRECT worksheet function in help - I think it may do what you're looking
to do.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]