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...
catherine9910 Try it this way:
=IF(XLOOKUP(A3,'Automated Stats'!B:B,'Automated Stats'!F:F)="HS","HS","")
- 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.
