Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down Plus Match, I think!
I need to make a reference from the drop down list to match a specific price
in the list... Eg. Part A = 500 Part B = 600 Part C = 700 Now my drop down list would be the Parts, but I need to ensure that if Part A is chosen, 500 will automatically be entered in the next cell. How do I do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down Plus Match, I think!
See if this helps:
http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "Leanne" wrote in message ... I need to make a reference from the drop down list to match a specific price in the list... Eg. Part A = 500 Part B = 600 Part C = 700 Now my drop down list would be the Parts, but I need to ensure that if Part A is chosen, 500 will automatically be entered in the next cell. How do I do this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down Plus Match, I think!
Assume that the Part-Price reference table
is in Sheet2's cols A & B, eg: Part A 500 Part B 600 Part C 700 etc In Sheet1, Assume your DVs to select the parts are in A2 down In B2: =IF(A2="","",VLOOKUP(A2,Sheet2!A:B,2,0)) Copy down as far as required Do high-five this response by clicking the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:23,000 Files:370 Subscribers:66 xdemechanik --- "Leanne" wrote: I need to make a reference from the drop down list to match a specific price in the list... Eg. Part A = 500 Part B = 600 Part C = 700 Now my drop down list would be the Parts, but I need to ensure that if Part A is chosen, 500 will automatically be entered in the next cell. How do I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MAtch drop down list selection to data sheet | Excel Worksheet Functions | |||
MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
INDEX and MATCH w/ Drop Down Lists | Excel Worksheet Functions | |||
Drop down lists and vlookup? or Match? | Excel Worksheet Functions | |||
"Suggest a match" from a list or drop down. | Excel Worksheet Functions |