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...
Not sure if the first response saved....On a test file I came up with the following
=INDEX(G:G,MATCH(1,IF(E:E=E16,IF(F:F=F16,1)),0)) (i.e., E16 ~ item number and F16 ~ "True" or "False" as required)
Thank you so much MKoski!!! That works! This is amazing, we were splitting reports to separate the pots and that part was confusing people who aren't comfortable with excel. Much appreciated, I hope you have a great day!