VLOOKUP on multiple columns

I've used VLOOKUP based on matching one column and returning one result. No problem. Now I need to return one result based on 3 columns matching.

Assume this range of columns is named: TravelDays
Origin...Location...ShipVia...TravelDays
33778...420...UPS...3
33778...425...UPS...1
33778...440...UPS...3
33778...443...UPS...3
33778...446...UPS...2
33778...447...UPS...3
33778...449...UPS...5
33778...475...UPS...3

What I'm trying to accomplish is if these columns match:
i2=Lookup!TravelDays,1
E2=Lookup!TravelDays,2
N2=Lookup!TravelDays,3

My result should be: Lookup!TravelDays,4

How do I approach this?
Thanks!

look up 33378 and 447 and UPS to get 3

Correct.

Is Origin in Col I, Location in E, and Ship Via in N

I have a worksheet that I input data into and another worksheet named 'Lookup' where I hold my lookup ranges.
The columns I, E and N on my worksheet must match the respective columns in my range named: TravelDays.

INDEX/MATCH and you will need to use an Array function

I believe you are correct. Off to more education!

Thanks!

Using Excel 2007 with 2 worksheets in same workbook.
Tab1 = PO
Tab2 = Lookup

Attached S1 screenshot shows the range TravelDays on the Lookup tab.

On worksheet PO, I have 3 columns:
I - Contains origin
E - Contains ship to location
N - Contains ship method

Assuming I get a match on the above 3 columns with the respective columns in range TraveDays, I should get column 4 in TravelDays range.

thanks!

I don't think I'm communicating this very well. Let me try again.
Range "TravelDays" is on worksheet "Lookup"
Worksheet PO is where I input the criteria values.
I2 must match Lookup!TravelDays column [Origin] and
E2 must match Lookup!TravelDays column [Location] and
N2 must match Lookup!TravelDays column [ShipVia]

Assuming the above 3 columns are a match:
Cell S2 on worksheet PO will reflect my desired result which will be Lookup!TravelDays column [TravelDays]

Thanks!

Maybe more clear if you upload you sample file, click "Go Advanced" button and find paperclip button to attach the file.

Attached is a sample

thanks!

In Excel, one should ba able to reference the range name and column number in formulas. Makes life simpler.

Short Hand Example: TravelDays,1

I noticed you code the above as $A$2:$A$9

I switched your cell reference to TravelDays,1 and the formula errors.

Is this short hand way of referencing a cell range not allowed in INDEX MATCH formulas? Or am I missing something again?

Thanks for your help!

Your name ranges select table include table header, that might be cause you error, change name ranges to just your data only

@ChemistB

Sure do

The help is greatly appreciated. I ran into another issue. On the PO tab I provided 4 sample rows. As time passes there will be hundreds of rows. I tried adding more data rows then copying the formula vertically. Error: cannot change part of an array. I'm learning the quirks of arrays. Is there another way around this?

thanks!

Shazam! It all works now.
The help is much appreciated.