Assuming that there are unique values in one of the columns of the
table that you could use to find the value you want, you need to use a
VLOOKUP formula (if the column of unique values is on the left) or a
combination of INDEX and MATCH (if it is not).

If this is not sufficient to help you, please give an example of what
the source table contains and say which value you want to access by a
formula

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup