jeudi 28 octobre 2021

Random of Table Header Name of another table via INDEX MATCH

I have these 2 tables: enter image description here

On column B i'm trying to get one of the Header Names of a feature that is not empty on Table B. I want it to be selected randomly. The order of the items in Table A can be different than the order of the items in Table B, I'll need some sort of INDEX MATCH here too.

Any help will be greatly appreciated.




Aucun commentaire:

Enregistrer un commentaire