View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jas jas is offline
external usenet poster
 
Posts: 1
Default 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.