Help with pulling data from a table

Hi all

I was wondering how (if possible) you can get excel to pull data from a table, dependant on the values of two cells.

My specific example is if you imagine a mileage chart, with a list of 10 destinations listed down the page and then the same 10 destination listed across the page (in an x and y axis) then the corresponding mileages between destinations in the resulting grid table.

Could you then get excel to pull the correct mileage out from the table if you enter two destinations on a worksheet?

Thanks

cattlegrid_79,

Try,

=OFFSET($A$1,MATCH(J1,$A$1:$A$5,0)-1,MATCH(J2,$A$1:$E$1,0)-1)

Where J1 and J2 are your destinations and A1:E5 is your grid.

HTH

Steve

Hey

thanks for this. It kind of nearly works, but every now and then it returns one of my row or column headers as a result.

Any ideas?

cattlegrid_79,

I did not run into this problem. How is your grid set up exactly? I had a blank cell in A1 and then in A2:E5 were cities and B1:E1 cities.

Steve