Results 1 to 3 of 3

Need help getting LAMBDA to work

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-11-2020
    Location
    Kansas City
    MS-Off Ver
    Office 365
    Posts
    162

    Need help getting LAMBDA to work

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel ; Accumulate by month using LAMBDA
    By Dicken in forum Office 365
    Replies: 12
    Last Post: 12-13-2023, 12:27 PM
  2. [SOLVED] Using TEXTSPLIT with MAP and LAMBDA is not working
    By Jacc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-17-2023, 03:15 PM
  3. [SOLVED] Bisectional method using recursive Lambda
    By Jacc in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 09-07-2023, 05:19 PM
  4. [SOLVED] Maximum Drawdown and LAMBDA
    By andrewc in forum Excel General
    Replies: 5
    Last Post: 06-28-2023, 09:25 AM
  5. [SOLVED] Replace Repetitive Formulas With Lambda?
    By helmanfrow in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-26-2023, 06:57 AM
  6. [SOLVED] LAMBDA iteration
    By Slabu in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-20-2021, 08:39 PM
  7. Lambda Expressions in Excel VBA
    By Gregor y in forum Tips and Tutorials
    Replies: 4
    Last Post: 10-17-2014, 06:59 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1