Mar 22 2021 11:46 AM
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?
Mar 22 2021 12:04 PM
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