=INDEX(B2:BB700,MATCH(A750,A2:A700,0),MATCH(A751,B 1:BB1,0))

--
Regards,

Niek Otten
Microsoft MVP - Excel

"Steved" wrote in message
...
Hello from Steved

I have a very large spreadsheet with Kilometres.
Row 1A to Row 1BB I have headings for Suburb Names
Column A1 to Column A700 I have headings for Suburb Names
In Column A29 I have a Suburb called Devonport
In Row 1G I have Suburb Called Ranfurly
In G29 the kilometres from Devonport to Ranfurly is 16.5
I would appreciate a application that I type in Devonport
and then Ranfurly it would look in column A to find
Devonport, and then look in Row 1 to find Ranfurly, The
answer I need comes up with is cell G29. In cell G29 is
16.5.

Thankyou