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...
Why same formula two times?
I believe I made a mistake when I created the snip. Hopefully this one is better. I used the same formula twice because I need the same return on all lines in that column (usually there are about 20 lines).
--------------------------------------------------------------------------------------------------------------------------