Forum Discussion
Automatically Generate criteria based on value location
I'm looking for help with a particular problem im facing which seems like it should be simple but i'm not aware of the correct way to tackle it. Im working on a spreadsheet in excel where i need the ...
In B6:
=IFERROR(INDEX($A$2:$A$5,MATCH(1000000,B$2:B$5)),0)
or if you have Microsoft 365/Office 2021:
=XLOOKUP(1000000,B$2:B$5,$A$2:$A$5,"",-1)
Fill to the right.