Forum Discussion

em_st3r's avatar
em_st3r
Copper Contributor
Aug 29, 2022
Solved

What formula should I use?

I need help setting up a formula that will be able to pull in the correct column of data from a separate tab when the date is changed. I am unsure which formula to use to get my desired result. I hav...
excel
Formulas and Functions
  • mtarler's avatar
    mtarler
    Aug 29, 2022

    em_st3r got it and here is the example using Filter().  i also used data validation to create a drop down for the date selection.

em_st3r's avatar
em_st3r
Copper Contributor
Aug 29, 2022
did you get my message?
mtarler's avatar
mtarler
Silver Contributor
Aug 29, 2022

em_st3r got it and here is the example using Filter().  i also used data validation to create a drop down for the date selection.

  • em_st3r's avatar
    em_st3r
    Copper Contributor
    Aug 29, 2022
    amazing thank you so very much!

Resources