Forum Discussion

Red_Handler's avatar
Red_Handler
Copper Contributor
Dec 14, 2022

Performing a lookup where the lookup value appears multiple times (incrementally through rows)

I have been puzzling over the following.  Have a table that looks a bit like this: What I want to do is populate. second worksheet and record Module 1, 2, and 3 completions, by entering a '1'...
excel
Formulas and Functions
Lorenzo's avatar
Lorenzo
Silver Contributor
Dec 15, 2022

Red_Handler 

 

in J3 and copy right:

=IF(
  COUNTIFS(Data[[Code]:[Code]],Report[@[Code]:[Code]],
    Data[[ModuleCompleted]:[ModuleCompleted]],Report[[#Headers],[Module 1]]
  ), 1, "Not completed"
)

Resources