Lookup Formula Using Multiple Values

K

Kay Castles

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Asterisk in VLOOKUP search 2
Return Value from cells which match criteria (complex) 2
Populating a null field in record with previous record value 0
Lookup ? 1
Reading Previous record of field and inserting it into current If Is Null?? 2
lookup and return column number 2
lookup value for form multiple combination in a Matrix 5
Use SUMIF, VLOOKUP, HLOOKUP, LOOKUP, AND ?? 6

Top