Forum Discussion
Index function not working
Hi, I have a table of postcodes in the UK and times that a vehicle can first reach in the top row as my header. I have used a left function to break down the 4 possibilities from the postcode (p...
SergeiBaklanPlease see attached file
Another, and more safe variant, could be
=IF(
SUMPRODUCT(($A$1:$J$10000=M6)*COLUMN($A$1:$J$10000)),
INDEX($A$1:$J$1,1,SUMPRODUCT(($A$1:$J$10000=M6)*COLUMN($A$1:$J$10000))),
"no such"
)