Hi,

This assumes a table in A1 - H13 and the 2 lookup values in J1 & K1.

=INDEX(A1:H13,MATCH(J1,A1:A13,0),MATCH(K1,A1:H1,0) )

Mike

"willemeulen" wrote:

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