Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application to find Kilometres
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The formula works if I copy from Auckland Kilometres | Excel Worksheet Functions | |||
Potential Bug in Find All application | Excel Discussion (Misc queries) | |||
find application | Excel Discussion (Misc queries) | |||
Can't Find Microsoft Application Recovery | Excel Discussion (Misc queries) | |||
Kilometres Calculator | Excel Worksheet Functions |