View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
willemeulen willemeulen is offline
external usenet poster
 
Posts: 27
Default vlookup, hlookup and return value of intersecting cell

I want to lookup a value of intersecting cells, find rate for specific trip.
The rates are now summarized in a table by looking up first column and top
row the intersecting cells give the rate. how do I do this.

Column A (Departure)
Column B (Destination)
Column C (Rate)

When column C is complete i will select all cells to arrange it according to
rate of trip.

Thanks

W