# Excel Lookup Formula for table

Microsoft Excel 2003 (full product)
February 24, 2010 at 06:30:45
Specs: Windows XP
 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 youedited by moderator: Post moved from Windows XP Forum to Office Software Forum

See More: Excel Lookup Formula for table

#1
February 24, 2010 at 11:40:13
 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 25 ```Temps across top in Row 1 from Column B through FHumidity down column A starting at A2 through A6The cells in between are populated in what ever manner you wish, I simply put in consecutive numbers.In Cell A8 enter the word HumidityIn 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.MIKEhttp://www.skeptic.com/

Report •

#2
February 24, 2010 at 19:03:54
 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.

Report •
Related Solutions