Dropdown Pull Specific selected

[ineedsomemajorhelp]

I am trying to find the correct formula for C2 to pull the corresponding payment amount based on the dropdown selected. For example, if "Troubadour" is selected, a corresponding "$100.00" shows up in D2.

 

[kweaver]

Welcome to Mr. Excel

You have a better chance of getting a reply if you show data sample(s) w/expected results and where they come from AND you use XL2BB.
For example, why would Troubadour result in 100? Where does that come from? What about the other options?

 

[ineedsomemajorhelp]

Welcome to Mr. Excel

You have a better chance of getting a reply if you show data sample(s) w/expected results and where they come from AND you use XL2BB.
For example, why would Troubadour result in 100? Where does that come from? What about the other options?

Hello, 100 represents the amount paid.

Troubadour - 100
Inner Circle - 100
Sound Engineer - 50
Video Editor - 30

I would like it to pull the corresponding payment amount in the column next to it the name.

 

[kweaver]

Do you mean something like this?

Book2
	C	D	E	F	G	H	I
1	Type	Amount
2	Troubadoure	100				Inner Circle	100
3	Video Editor	50				Sound Engineer	50
4						Troubadoure	100
5						Video Editor	50
dropdown

Cell Formulas
Range	Formula
D2:D5	D2	=XLOOKUP(C2,$H$2:$H$5,$I$2:$I$5,"")

 

[ineedsomemajorhelp]

Do you mean something like this?

Book2
	C	D	E	F	G	H	I
1	Type	Amount
2	Troubadoure	100				Inner Circle	100
3	Video Editor	50				Sound Engineer	50
4						Troubadoure	100
5						Video Editor	50
dropdown

Cell Formulas
Range	Formula
D2:D5	D2	=XLOOKUP(C2,$H$2:$H$5,$I$2:$I$5,"")

YES! Thank you!