I’m making a football worksheet and I’m not able to pass an image from one tab to another.
Inside the worksheet I have tabs that correspond to the championship rounds, and inside these tabs I wanted to put the name of a team and the badge of that team next to it.
Tab "Round 38" – I want to put the badge in the B column
That’s why I created another tab with just the name of the teams and the shield right next to it.
This tab is called "Escudos"
What I want to do is, when I put the team name in column C, the shield referring to the team appears in column B.
I tried using OFFSET and VLOOKUP, but I couldn’t make it work, most likely because I’m still a layman in excel.
>Solution :
Try this in B4 (I estimate that this is the first cell based on your picture, if not change B4 and C4 based on your first row):
=INDEX(Escudos!C:C,MATCH(C4,Escudos!B:B,0))
Or just with this formula in B4 you can have the full column filled (remember to delete everything below it in B column):
=byrow(C4:C,lambda(each,if(each="","",INDEX(Escudos!C:C,MATCH(each,Escudos!B:B,0)))))