Need help getting LAMBDA to work

[Newtonus_Prime]

I am trying to conditionally highlight rows when specific criteria are met. I found a formula that worked in Google Sheets and can't get it to function in excel.

What I am trying to do:

I am currently pasting info into a tab called "Daily Totals"-

I need to highlight rows in "Approved Jobs" when the (Job #- Column B) and (letter code- Column C) match in the "Daily Totals" tab (Columns B & C)

I can't seem to get the formula below to work with it.

=LAMBDA(job,letter_code,COUNTIFS(job,$B8,letter_code,$C8)>0)(INDIRECT("'Daily Totals'!B:B"),INDIRECT("'Daily Totals'!C:C"))

Thank you in advance,
Adam

[DJunqueira]

Your lambda formula doesn't look good to me, where is it?

Trying to help anyway I did the new formula in column V of sheet Daily Totals.

Please Login or Register  to view this content.

Column W has an equivalent one, lets see if we go somewhere..

[Newtonus_Prime]

Sorry for the confusion, I am trying to get the rows in the "Approved Jobs" tab with Job #'s and Lettercode/ Part that match in the Daily Totals to conditionally highlight. I will be pasting the data into "Daily Totals" tab from another sheet- My list on "Approved Jobs" is my reference to confirm that jobs for each day are complete.

On another note: I couldn't get my LAMBDA formula to work without errors, so it wasn't in the sheet. I was hoping that someone could figure out what I had done wrong.

I really appreciate your help- is it possible to highlight the rows in the "Approved Jobs" tab when those criteria are met?

Thank you,
Adam