Forum Discussion

Copper Contributor

Oct 26, 2019

Formula to pull from multiple columns in (IF/THEN) into field on another tab?

Am trying to get a formula to calculate the following from image below: Search column L for a value, AND search date range in column R, if both are true, then sum related values in Column W. I thou...

excel

Excel on Mac

MCovart

Copper Contributor

Dec 12, 2022

Hello, I am trying to create a formula that if on tab1 column A & column B match Column A & column D on tab2 then it generates a number in column E on tab1

Is that possible?

Thank you,

Michelle Covart

kmb126