Populating multiple cells with drop down

  • Re: Populating multiple cells with drop down


    You can use Index/Match.


    e.g. to get the Mid Winter rate:


    [COLOR="#0000FF"]=INDEX([COLOR="#FF0000"]tbl_items[Winter Mid][/COLOR],MATCH(B1,tbl_items[itemnum],0))[/COLOR]


    you would just need to change the [COLOR="#FF0000"]Red [/COLOR]reference to point to relative column you need results from.

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!