Excel Lists

Occasional Visitor

I am wanting to pull the next value in a sequence from a list, and potentially 4 lists depending on type and then remove that value from the list so it is no longer available. I have tried lists. I have tried setting up IF statements. All attempts have failed. The attached has a page with lists, and the main spreadsheet for tracking up to date information. Any ideas? 

1 Reply

Hi @mechanical12825 


Using index / match function you can easily pick the required data based on lookup values.  Please use belwo formula:



You may also refer the attached file.


Please let me know if it works for you,