ScottTemple
Board Regular
- Joined
- Dec 28, 2023
- Messages
- 103
- Office Version
- 365
- Platform
- Windows
Hello,
I would like to create a formula that includes Xlookup and then, based off of what is returned, finish the formula with that data, along with data from other cells. I'm not certain how to even begin writing this formula though.
An example would be:
=XLOOKUP(A2,Table1[Setup],Table1[Time],0),IF(B2>C2,(B2-C2)*1440)+datafromxlookup),(1-C2+B2)*1440)+datafromxlookup))
I would like to create a formula that includes Xlookup and then, based off of what is returned, finish the formula with that data, along with data from other cells. I'm not certain how to even begin writing this formula though.
An example would be:
=XLOOKUP(A2,Table1[Setup],Table1[Time],0),IF(B2>C2,(B2-C2)*1440)+datafromxlookup),(1-C2+B2)*1440)+datafromxlookup))