Drop Down Plus Match, I think!

[Leanne]

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?

 

[T. Valko]

See if this helps:

http://contextures.com/xlFunctions02.html

 

[Max]

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