Google sheets formula help for lottery system.

Reply #4

hypersoniq — Thu, 27 Feb 2025 12:06:14 GMT

Glad that it worked. We have probably all been in the same spot where staring at a formula on a spreadsheet that should work but doesn't for some odd reason becomes exhausting.

Reply #3

MzDuffleBaglady — Thu, 27 Feb 2025 06:17:04 GMT

Reply #2

ScreamingMidget — Thu, 27 Feb 2025 06:11:05 GMT

Oh wow. So all I had to do was nest one of those lines within a (INDIRECT( xxx )?

Dang..... was it really that easy. LOL. I've been staring at it for too long trying to figure it out haha.

It worked, thank you so much

Reply #1

hypersoniq — Thu, 27 Feb 2025 03:33:54 GMT

The ARRAYFORMULA and XMATCH nesting can get weird with references when you add or delete rows. Try this version and see if it fixes the issue...

=IFERROR(

XMATCH(0,

ARRAYFORMULA(

(INDIRECT( Pick3Draws!$B$5:$B$1000 ) = B2) +

(INDIRECT( Pick3Draws!$B$5:$B$1000 ) = C2) +

(INDIRECT( Pick3Draws!$B$5:$B$1000 ) = D2) +

(INDIRECT( Pick3Draws!$C$5:$C$1000 ) = B2) +

(INDIRECT( Pick3Draws!$C$5:$C$1000 ) = C2) +

(INDIRECT( Pick3Draws!$C$5:$C$1000 ) = D2) +

(INDIRECT( Pick3Draw... [ More ]

Google sheets formula help for lottery system.

ScreamingMidget — Wed, 26 Feb 2025 20:47:53 GMT

I have 2 sheets, one with drawings on it. Let's call it Pick3Draws

I have another sheet, let's call it Pick3system

Draws on Pick3draws start at row 5, and the digits are in individual columns, so

B5, C5, and D5.

On the Pick3system sheet, I have a formula that's comparing to a list of combos, combos starting at B2,B3,B4

individual digits. Here's the formula:

=IFERROR(

XMATCH(0,

ARRAYFORMULA(

(Pick3Draws !$B$5:$B$1000 = B2) + (Pick3Draws !$B$5... [ More ]