How Can i do it pls ????

[amony89]

hello I wonder if someone helps me to do this in excel
<a href="https://ibb.co/mE35c6"><img src="https://thumb.ibb.co/mE35c6/Capture.png" alt="Capture" border="0"></a>
i have a list containg of two values (lecture ,eng)
the question is how can i put salry automatically when i slected the values (lecture ,eng) in the salry colums???

 

[Joe4]

Welcome to the Board!

I think we need more details. Where is this salary figure that you want populated automatically coming from?

 

[amony89]

i want the salary come from the degree , the bottom line is to give each value from the list when i selected must appear in the salry colms

 

[Joe4]

i want the salary come from the degree

You need to explain this step.
Do you have a lookup table somewhere, that lists each degree and the corresponding salary?

If so, simply use a VLOOKUP formula to get the salary.
See: https://www.techonthenet.com/excel/formulas/vlookup.php