Thread: 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

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