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...
I need to return the Final Sku on all lines in that column, usually there are about 20 lines. The same flowers are sold with pots as without pots which is why the skus are the same, only difference is the P. I keep getting the "flowers" sku returning on all line no matter if there are pots or not. I hope that makes sense. LOL
It's still confusing - originally you had the same Item Number in E5 and E6, now you have different ones, so a straight XLOOKUP will work.
Yes, I can get the XLOOKUP to work, but it will only return the sku that doesn't include a "P".
I need to be able to find the inventory quantity for the flowers and the inventory quantity for the flowers with pots. The only difference in the sku is the "P".