Vlookup using drop downs and table
 

On one worksheet I have a validation table (drop down menu) using column A
from 2nd worksheet in the same workbook. In a second cell I have a
validation table (drop down menu) from row 1 in the 2nd worksheet. In a
third cell, I am trying to put a formula to retrieve the intersection of the
two cells.

As an example: 1st cell selects Ford Contour from Menu, 2nd cell selects
2000. I want the 3rd cell formula to = $3,325.00

I am using 8 years and about 70 makes and models.

MAKE & MODEL 1999 2000 2001
Chevrolet/GMC Envoy $9,500.00 $11,100.00$0.00
Chevy Venture Mini $4,075.00 $4,375.00 $5,925.00
Ford Contour $2,550.00 $3,325.00 $4,000.00
Ford Crown Victoria $4,975.00 $6,025.00 $7,375.00

I greatly appreciate your help! This is for a certification for personal
use of a company car. There are over 2000 employees filling out a horrible
manual document and I am trying to automate as much of the process as
possible.

Thank you!

Wendy

Vlookup using drop downs and table
 

Debra Dalgleish has some notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

You'll want to look at example 2 of the second link.

Wendy - Payroll wrote:

On one worksheet I have a validation table (drop down menu) using column A
from 2nd worksheet in the same workbook. In a second cell I have a
validation table (drop down menu) from row 1 in the 2nd worksheet. In a
third cell, I am trying to put a formula to retrieve the intersection of the
two cells.

As an example: 1st cell selects Ford Contour from Menu, 2nd cell selects
2000. I want the 3rd cell formula to = $3,325.00

I am using 8 years and about 70 makes and models.

MAKE & MODEL 1999 2000 2001
Chevrolet/GMC Envoy $9,500.00 $11,100.00$0.00
Chevy Venture Mini $4,075.00 $4,375.00 $5,925.00
Ford Contour $2,550.00 $3,325.00 $4,000.00
Ford Crown Victoria $4,975.00 $6,025.00 $7,375.00

I greatly appreciate your help! This is for a certification for personal
use of a company car. There are over 2000 employees filling out a horrible
manual document and I am trying to automate as much of the process as
possible.

Thank you!

Wendy

--

Dave Peterson