Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a table of 8 labels Horizontal by same 8 vertical. If in a form I
enter one of the Horizontal and one of the Vertical labels How do I get one cell to display the intersection value of the horizontal/Vertical labels. Ex; the table has 8 locations Hor and 8 vert. the intersection is the distance from one to the other. If I enter in the form From: PLACE A To: Place B (50 miles)How do I write a formula that displays those 50 miles . I have tried the lookup wizard but it seems to work only with 1 row and 1 column. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup Wizard | Excel Worksheet Functions | |||
Conditional sum wizard | Excel Worksheet Functions | |||
Allow the use of the fx wizard within the fx wizard for nesting | Excel Worksheet Functions | |||
lookup wizard | Excel Discussion (Misc queries) | |||
Wizard | Excel Discussion (Misc queries) |