Forum Discussion
IF + XLOOKUP Formula
Hello, I am trying to put 2 formulas together. I have gotten the XLOOKUP formula to work perfectly, but not when I added the IF statement (only if the column says "HS"). =XLOOKUP(A3,'Automat...
XLOOKUP formula is the value that I want it to return if column F:F is "HS"
catherine9910 Column F:F is the return array, so when the returned value from XLOOKUP = "HS" you have found what you are looking for, and you want the formula to return "HS". If the value found in F:F is not "HS" you want to return "". But perhaps I don't get it. Sorry.
- I added an example file of what I am needing help with.
catherine9910 Thanks. That helps a lot as I would not have guessed your intentions otherwise. Please see attached. I believe it does what you need.
- Real quick, this formula returns the #DIV/0 error. How do I get it to return zero instead of that error?
=(H3+I3)/J3