Forum Discussion

benross94's avatar
benross94
Copper Contributor
Apr 17, 2023
Solved

Need help Complex Look Up Formula

Hello, I am looking for help with https://1drv.ms/x/s!AsAcHcm1UiD3drNnfXaBu7aPx5M?e=DwVlT1 The task: In the CRM Report tab, columns F onward, I want to pull the names of people who were on a given...
excel
Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    Apr 17, 2023

    benross94 Your formula is working fine to me. What error do you get? You may simplified the formula using nested FILTER() function. Try-

    =TOROW(FILTER('TRUCK CREWS'!$B$4:$B$19,FILTER('TRUCK CREWS'!$C$4:$P$19,'TRUCK CREWS'!$C$3:$P$3=E2)=D2))

    By the way, what is your excel version?

     

Harun24HR's avatar
Harun24HR
Bronze Contributor
Apr 17, 2023

benross94 Your formula is working fine to me. What error do you get? You may simplified the formula using nested FILTER() function. Try-

=TOROW(FILTER('TRUCK CREWS'!$B$4:$B$19,FILTER('TRUCK CREWS'!$C$4:$P$19,'TRUCK CREWS'!$C$3:$P$3=E2)=D2))

By the way, what is your excel version?

 

benross94's avatar
benross94
Copper Contributor
Apr 17, 2023

Harun24HR This worked, thank you!

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Apr 18, 2023
    If it works then please tick mark the answer to treat the thread as solved.

Resources