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?

     

FikturFox's avatar
FikturFox
Brass Contributor
Apr 17, 2023
Perhaps like this?
=IFERROR(TOROW(IF(XLOOKUP(E2;'TRUCK CREWS'!$C$3:$P$3;'TRUCK CREWS'!$C$4:$P$19;"")=D2;'TRUCK CREWS'!$B$4:$B$19;NA());3);"")

Resources