|
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? |
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? |
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? |
| All times are GMT +1. The time now is 04:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com