Multiple Column Lookup

[Studk22]

I'm putting together a lookup tool. The columns are types of cars (trucks, SUV's, vans, cars), paint colors available on each car (green, red, blue, yellow), and the third column is the car name (F150, F350, Envoy, Astro Van, Grand Prix, Grand Am). The fourth column (which is the column I'd like to return as the answer) is the regions in the world each type of car, by color, by name is available in.

I have three validations lists set up where I can select the type, color and name. Underneath the selections is a cell to show the answer to where that specified vehicle is available (regions available). How do I create a lookup function based on the type, color and name of the vehicle to return where it is available (regions available)?

 

[jae113]

TEXT(VLOOKUP(B19,Sheet2!$A$1:$B$15,2,FALSE) - I19 + TODAY(),"m/d")

B19, in this case, is where I want the answer to go.

Sheet 2 is where I have my lookup table

$A$1:$b$15 is the range of my data (2 columns by 15 rows)

2 is the number of columns

and false is to end the formula

You don't need the rest, I don't think....

 

[Studk22]

I'm not understanding how this applies to my question.

 

[jae113]

I think you can make a lookup table similiar to that one, and it should work