Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help for formulas/layout?
I am trying to create a table with train station data and price of travel
which is to look up another sheet with the traveling details. I have no idea what to use then how to organise this. Details: One sheet in the workbook has a cross reference table with stations and cost. The other sheet has "From station" "To station" travelled but no "Cost" data entered. How do I get this info to refer to the data table against the stations travelled?? VL/array/If functions, which? Appreciate some help getting started please. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help for formulas/layout?
And here's a formula stolen from Peo Sjoblom (and others):
=INDEX(Table,MATCH(A1,INDEX(Table,,1),0),MATCH(B1, INDEX(Table,1,),0)) If you create a range name referring to your cross reference table (Insert|Name|Define) and call it Table, it'll make your typing life a little easier. (But you could use the address (Sheet2!$a$1:$x$9999) in place of Table in the formula. And A1 will hold the value to match on the column (to get the right row) and B1 will be used to get the correct column. jas wrote: I am trying to create a table with train station data and price of travel which is to look up another sheet with the traveling details. I have no idea what to use then how to organise this. Details: One sheet in the workbook has a cross reference table with stations and cost. The other sheet has "From station" "To station" travelled but no "Cost" data entered. How do I get this info to refer to the data table against the stations travelled?? VL/array/If functions, which? Appreciate some help getting started please. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Layout | Excel Discussion (Misc queries) | |||
Page Layout | Excel Worksheet Functions | |||
Can I switch from Office 2007 layout to the old 2003 layout? | Excel Discussion (Misc queries) | |||
A4 layout | Excel Discussion (Misc queries) | |||
I want to copy only the layout and formulas and not the exisiting | Excel Discussion (Misc queries) |