Excel Lists

[mechanical12825]

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? 

[#2]

Hi @mechanical12825 

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

=INDEX(LIST!$A$4:$D$4,1,MATCH(K13,LIST!$N$2:$Q$2,0))

You may also refer the attached file.

Please let me know if it works for you,

Thanks

Tauqeer