I have a chart with the top row A1:AJ1 numbers 1 thru 10. On the left side Column A1:A10 are also a set of numbers1 thru 10. The cells down and across are the numbers I need to look up. If cell A25 shows a 2 and cell a
A26 shows a 4. How can I right a formula that will find the correct cell on the top row to match A25 (2) and the correct cell on the left column A26 (4) and show the number from the chart where the column and the row intersect in A27?
This is the third time I have asked this question, mayby third times a charm. Thanks for looking and many thanks if you can answer it.
JoeBed