I am tryingto create a formula in excel that if i give it a number it would find it on the x axis of a table, and then a second number it would foind it in the y axis of the same table. For example, if i told it that there is a relative humidity of 59 (x value) and a temperature of 65 (y value) how could i get it to tell me that the number that i want is 8. These would all be in a table format so i just need the table to find where x and y meet.

Thank you

edited by moderator: Post moved from Windows XP Forum to Office Software Forum

Not sure if this is what you want but try this: Your table is set up as:

50 55 60 65 70 10 1 2 3 4 5 20 6 7 8 9 10 30 11 12 13 14 15 40 16 17 18 19 20 50 21 22 23 24 25Temps across top in Row 1 from Column B through F

Humidity down column A starting at A2 through A6

The cells in between are populated in what ever manner you wish, I simply put in consecutive numbers.In Cell A8 enter the word Humidity

In Cell A9 enter the word TempIn Cell B8 enter the Humidity number your looking for.

In Cell B9 enter the Temp your looking forIn Cell B11 enter this formula:

=INDEX(B2:F6,MATCH(B8,A2:A6,0),MATCH(B9,B1:F1,0))

This should give you the intersecting number.

So if you enter 40 for the Humidity number and 70 for the Temp number you should get 20 as the intersect.MIKE

To avoid #N/A errors with Mike's fine suggestion, put Drop Down validation lists in B8 and B9 based on A2:A6 and B1:F1 respectively.

Ask Your Question

Weekly Poll