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 product name to populate a cell at the bottom of a table dependand on the location of the value populated above it.
Highlighed yellow in the picture attatched is where i would need the name of the product to populate based on whether there is a tonnage value added to the line of the product or not.
Many thanks in advance.
1 Reply
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.
