Forum Discussion
Looking for Xlookup with IF function
Hi! I'm trying to find a formula that allows me to search for a sku in column E but I need the return to be based on whether or not the cell in column F says True or False. If it's true, I need to...
This is confusing. A formula in column H cannot look up something in the entire column H - that causes a circular reference. Perhaps you simplified the example too much?
It looks like my reply didn't save...
Maybe this can help, I'm not great at formulas.
-------------------------------------------------------------------------------------------------------------------
