Help for formulas/layout?

  • Thread starter Thread starter jas
  • Start date Start date
J

jas

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.
 
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.
 
Back
Top