G
Guest
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
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