You could use programming to find a number in a table, and return its
row and/or column number. Is that what you're trying to do?

Jim wrote:
I'm not sure how to check a given value against a chart in the spreadsheet to
find a corresponding value in the chart. If there is a value 25 let's say in
a cell, I need to be able to look for 25 in a chart and find the value that
corresponds to it. I don't even know where to begin.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html