3 Row Cells Compared to 1 Column Of Values

[Rapidlywild]

Evening All,
So I trying to make use of some raw data regarding servers and their current installed patches. What I have available is Column A identifies the machine name, Column B, C and D identify the latest 3 installed patches on the machine. Then we have column G which lists the 6 most recent patch ID's.

In column E, I need a formula which looks at B2,C2 and D2 and if either one of them 3 appears in G2:G7 then it returns a TRUE value, and if doesnt appear, it returns a FALSE valud.

Sorry I am bad at trying to explain what I am seeking. If anyone understood and can assist, it would be GREATLY appreciates

 

[Juniad]

Try this in cell E2 and drag down.
=IF(SUMPRODUCT((B2=$G$2:$G$7)+(C2=$G$2:$G$7)+(D2=$G$2:$G$7))>0,TRUE,FALSE)

 

[V_Agarwal]

Assuming you have Excel 365, you may use this formula at E2 cell and then copy it down..
=OR(ISNUMBER(XMATCH(B2:D2,G:G)))

 

[pecoflyer]

Assuming you have Excel 365, you may use this formula at E2 cell and then copy it down..
=OR(ISNUMBER(XMATCH(B2:D2,G:G)))

XMATCH is available since XL2021 I believe (BTW referencing entire columns is not good practice)

 

[V_Agarwal]

XMATCH is available since XL2021 I believe (BTW referencing entire columns is not good practice)

It should not make any difference until we have a very big file having heavy formulas.

 

[p45cal]

In cell E2:

=SUM(COUNTIF(B2:D2,$G$2:$G$7))>0

May need array-entering onto the sheet (using Ctrl+Shift+Enter instead of just plain Enter) depending on your version of Excel. Then copy down.

 

[Peter Bartholomew]

= BYROW(installedPatches, LAMBDA(installed, OR(installed = latestPatches)))

or, fancied up a bit

= LET(
    Includesλ, LAMBDA(x, LAMBDA(y, OR(x = y))),
    BYROW(installedPatches, Includesλ(latestPatches))
  )

 

[Rapidlywild]

Thanks heaps, using work infrastructure and unfortunately its on 2019 excel. Tried using "=IF(SUMPRODUCT((B2=$G$2:$G$7)+(C2=$G$2:$G$7)+(D2=$G$2:$G$7))>0,TRUE,FALSE)" as suggested by Juniad and that has resulted in the TRUE/FALSE values that will help heaps. Thanks so much everyone :D