Hi Niek

The data is supplied below and I want to return a value such as:

Lookup Origin and Destination (eg: 1004 & Waipukurau) and return mileage
(eg: 75)

Cheers
Kay

"Niek Otten" wrote in message
...
Can you give an example of what data and what returned?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Kay Castles" wrote in message
...
Hi

I am using Microsoft Excel 2007 and I have data entered as follows:


Origin Destination Mileage
1004 Hastings 22
1004 Waipukurau 75
1005 Napier 22
1005 Waipukurau 53


I want a lookup formula that will lookup data in both the Origin and
Destination columns and return the value in the Mileage Column

Many thanks
Kay