Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP with TABLES | Excel Discussion (Misc queries) | |||
range names or check box | Excel Worksheet Functions | |||
Pivot Table questions | Excel Discussion (Misc queries) | |||
vlookup with validation table | Excel Discussion (Misc queries) | |||
Pivot table refresh | Excel Worksheet Functions |