I actually kind of got it. Thanks. In the previous file, Column A contains list of players and column B contains list of their teams (from cell 1 to 25). In cell C1, I intend to get a dynamic picture based on the data validation contained in cell D1.
Posts by Srisreshtan
-
-
The pictures are contained in column B of the logos sheet. Column A contains the list of cricketers.
-
I tried to link the team names (logos) with which is a player is associated to using Named range and indirect referencing in the logos sheet of the file
steps
a) data validation
b) linked picture and name of the player
c) copied the picture and pasted it near the data validation
d) gave a indirect referencing in the cell D1 by the name pic
e) While entering the formula after clicking the picture (= pic), it is showing an error.
-
How about
=INDEX($Q$38:$T$296,MATCH(1,(V38=$R$38:$R$296)*($W$37=$Q$38:$Q$296),0),MATCH($X$37,$Q$37:$T$37,0))
Or a non array version
=INDEX($Q$38:$T$296,MATCH(W$37&"|"&V38,INDEX(Q$38:Q$296&"|"&$R$38:$R$296,0),0),MATCH($X$37,$Q$37:$T$37,0))
It worked. Thanks a lot. But I am unable to understand how this formula works. Could please explain in brief?
-
I am getting an error while running the formula on index and multiple match in sheet Run Pivots and cell W38of the 'Valuation of the Indian Premier League' excel file.
Could anyone help me with respect to the correction.