Forum Discussion
Solved
Help Please! VLOOKUPIF?
I hope the use for this specific formula is clear. What I'm trying to do is add together the total value of clients based solely on UpCart (See Image Attached)
=(VLOOKUPIF(R5:R27,TRUE,(MIN(VLOOKUP(K1:K27,$X$17:$Y$25,2)),0)))
=IF(R4="x",VLOOKUP(K4,$X$17:$Y$25,2,TRUE),"")I'd add a helper column for the results of the VLOOKUP and then sum the results.
=SUM(S4:S26)This is the formula in cell S28.
If there were checkboxes in my sheet in column R the formula would be:
=IF(R4=TRUE,VLOOKUP(K4,$X$17:$Y$25,2,TRUE),"")
=IF(R4="x",VLOOKUP(K4,$X$17:$Y$25,2,TRUE),"")I'd add a helper column for the results of the VLOOKUP and then sum the results.
=SUM(S4:S26)This is the formula in cell S28.
If there were checkboxes in my sheet in column R the formula would be:
=IF(R4=TRUE,VLOOKUP(K4,$X$17:$Y$25,2,TRUE),"")
- Thank you for the help first and foremost, but dang, so no way to implement them both in one formula?
=SUM(BYROW(BYROW(R4:R26,LAMBDA(row,IF(row="x",OFFSET(row,,-7),""))),LAMBDA(x,IFNA(VLOOKUP(x,X17:Y25,2,1),0))))If you work with Office 365 or Excel 2021 or Excel for the web you can try this formula which returns the result in one step.
Which version of Excel do you work with? In older versions such as Excel 2013 there isn't a one formula solution as far as i know.
.png){kind=link}