Excel Lists

%3CLINGO-SUB%20id%3D%22lingo-sub-2228160%22%20slang%3D%22en-US%22%3EExcel%20Lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2228160%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20wanting%20to%20pull%20the%20next%20value%20in%20a%20sequence%20from%20a%20list%2C%20and%20potentially%204%20lists%20depending%20on%20type%20and%20then%20remove%20that%20value%20from%20the%20list%20so%20it%20is%20no%20longer%20available.%20I%20have%20tried%20lists.%20I%20have%20tried%20setting%20up%20IF%20statements.%20All%20attempts%20have%20failed.%20The%20attached%20has%20a%20page%20with%20lists%2C%20and%20the%20main%20spreadsheet%20for%20tracking%20up%20to%20date%20information.%20Any%20ideas%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2228160%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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:

=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