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 worked for me in a test file...
=INDEX(G:G,MATCH(1,IF(E:E=E16,IF(F:F=F16,1)),0))