Forum Discussion

Copper Contributor

Sep 03, 2025

Solved

Help with formula

Hello! If I'm trying create a formula that pulls data from one sheet into another. I want it to pull in data in column E if column B has a january date AND column C has the word discover in it, into ...

excel

Formulas and Functions

Countrygirl76
Sep 05, 2025
Thank you so much! That seems to be working!

=INDEX('My ✓ing'!E:E,MATCH(1,(MONTH('My ✓ing'!B:B)=1)*(ISNUMBER(SEARCH("Discover",'My ✓ing'!C:C))),0))

This is the formula that worked for what I was trying to do. I tried doing this but couldn't get it to work right, I think I was missing some () or something, again thank you so much for your help!

peiyezhu

Bronze Contributor

Sep 05, 2025

select * from My_✓ing;
select * from AccountInf;

create temp table aa as
select Account,substr(f01,1,2) m,f01 `Date`,f04 Paid from My_✓ing a,AccountInf b where regexp(lower(b.key),lower(a.f02));
select * from aa;
cli_one_dim~temp.aa~2;
select * from aaunion;
create temp table bb as
select Account,m||'_'||属性 ColLab,数量 from aaunion;
select * from bb;
cli_create_two_dim~bb~ColLab~数量;
select * from bb_two_dim;
cli_stack_headers~bb_two_dim~(.+)_(.+);