27 Oca 2022 ... I use this Index Match formula and it is very powerful. =INDEX(Sheet2!$A:$Z,MATCH(Sheet1!$A2,Sheet2!$A:$A,0),2) However, I now need something very similar.
How can I use Index Match to return multiple values horizontally?
This summary was compiled by our editorial team from publicly available information for quick reading. For full details, refer to original reporting where available.
