| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need to search a table such as distance table in road maps.
In a road map you normally find a distance table. I develop a spread sheet
simmilar to this and need to find the number where the column and line number meet. Thus if I enter Town one in A1 and Town two in A2, the formula is in A3, and will display the distance between the towns. When I change A1 or A2, A3 will show the new distance. Thank you. Ronnie. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
need to search a table such as distance table in road maps.
Ronnie wrote:
In a road map you normally find a distance table. I develop a spread sheet simmilar to this and need to find the number where the column and line number meet. Thus if I enter Town one in A1 and Town two in A2, the formula is in A3, and will display the distance between the towns. When I change A1 or A2, A3 will show the new distance. Thank you. Ronnie. Do a Google search for excel xindex |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
need to search a table such as distance table in road maps.
A A B C 1 1 14 11 14 14 2 4 7 1 3 9 13 12 Towns are A,B,C in row 1, columns C to E Towns are 1,2,3 in column B, rows 2 to 4 A1=A A2=1 A3 has formula =INDEX(C2:E4,MATCH(A1,$C$1:$E$1,0),MATCH(A2,$B$2:$ B$4,0)) Result is 14 HTH "Paul Lautman" wrote: Ronnie wrote: In a road map you normally find a distance table. I develop a spread sheet simmilar to this and need to find the number where the column and line number meet. Thus if I enter Town one in A1 and Town two in A2, the formula is in A3, and will display the distance between the towns. When I change A1 or A2, A3 will show the new distance. Thank you. Ronnie. Do a Google search for excel xindex |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
need to search a table such as distance table in road maps.
See if this old post helps:
http://tinyurl.com/rdlcx -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Ronnie" wrote in message ... In a road map you normally find a distance table. I develop a spread sheet simmilar to this and need to find the number where the column and line number meet. Thus if I enter Town one in A1 and Town two in A2, the formula is in A3, and will display the distance between the towns. When I change A1 or A2, A3 will show the new distance. Thank you. Ronnie. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i build a search table in excel | Excel Worksheet Functions | |||
| build a search tool in excel | Excel Discussion (Misc queries) | |||
| search from a data table | Excel Discussion (Misc queries) | |||
| search value in a table and sum another column | Excel Worksheet Functions | |||
| how to set up a vlookup table with 2 search terms? | Excel Worksheet Functions | |||
Linear Mode
