Forum Discussion

mechanical12825's avatar
mechanical12825
Copper Contributor
Mar 22, 2021

Excel Lists

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? 

Formulas and Functions

1 Reply

  • tauqeeracma's avatar
    tauqeeracma
    Iron Contributor
    Mar 22, 2021

    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

Resources