Forum Discussion

NeilKloster's avatar
NeilKloster
Brass Contributor
Apr 27, 2021
Solved

IF Functions & VLOOKUP Help needed

Hi everyone,    I'm trying to revamp something and I need some assistance.  I have an excel file 'productivity tracker' (I did not create the original) where on 'RAW' I have all my raw information....
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 27, 2021

    NeilKloster 

    That could be

    =IF([@[Tracking Type]]="Self-Reported Time",[@[Processing Time]],
  INDEX(Shared_Services_Expectations[Expectations (Hours)],
        MATCH([@[Service Level 1]]&[@[Service Level 2]],
              Shared_Services_Expectations[Category Level 1]&Shared_Services_Expectations[Category Level 2],
 0)))*[@[Service Count]]

    (in U2)

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 27, 2021

NeilKloster 

That could be

=IF([@[Tracking Type]]="Self-Reported Time",[@[Processing Time]],
  INDEX(Shared_Services_Expectations[Expectations (Hours)],
        MATCH([@[Service Level 1]]&[@[Service Level 2]],
              Shared_Services_Expectations[Category Level 1]&Shared_Services_Expectations[Category Level 2],
 0)))*[@[Service Count]]

(in U2)

  • NeilKloster's avatar
    NeilKloster
    Brass Contributor
    Apr 27, 2021

    SergeiBaklan 

     

    This worked perfectly!!  Thank you!! 

     

    I may reach out as I continue to navigate this, but thank you again - this helped get me over a large hurdle! 

Resources