How to Auto Fill certain cells

[egemen_i]

Hey guys I have a legue table like this. (Yellow highlighted)
On the right side i have another small table for calculating odds. Now on the orange part there is a drop down menu which helps me to pick a team. I want Excel to Auto Fill the red fields right next to it with A.GOL and A.YEN (gray, maroon arrows) according to team i picked. How can i do this?

Untitled.jpg

[grizzly6969]

perhaps you could post a sample of your workbook rather than a picture of it --- click go advanced to upload a workbook

[ByronVW]

It sounds like all you want to do is vlookup the team you select in the orange box and populate the corresponding values in the red cells. Below is the code, if this is not what you are looking for, upload a sample workbook or provide more clarity

In cell R5 type this

=vlookup($Q5,$A:$N,12,false)

In cell S5 type this

=vlookup($Q5,$A:$N,13,false)

You can copy this formula down for more teams if you want. Hope this is what you were looking for


Regards,
Byron

[egemen_i]

Thanks a lot Byron.
Solved.

[ByronVW]

Glad I could help mate