This is perfect!!!!! It was exactly what I needed. I found another tutorial to return Yes or No since that is what I needed instead of name or line number.
Worth noting (just cause I just went through this pain) - MATCH will allow you to use 'TRUE' as its first parameter, but that only works when you use the ampersand syntax & to string together your criteria. For this asterisk and parentheses syntax, using the '1' as the first for 'true' is critical. Microsoft Office documentation is always SO hard to sift online, so thanks so much for this video.
Thanks for the comment. Here's the link to the Excel file: docs.google.com/spreadsheets/d/1pIVAr68qzGutgBfQquccwV_DiR0Lgs29/edit?usp=sharing&ouid=112840883257889972521&rtpof=true&sd=true
This is perfect!!!!! It was exactly what I needed. I found another tutorial to return Yes or No since that is what I needed instead of name or line number.
You're welcome. I'm glad this helped.
Thank you for your hard work and hsaring your knowledge with us. 😊
Thank you. I appreciate that.
Worth noting (just cause I just went through this pain) - MATCH will allow you to use 'TRUE' as its first parameter, but that only works when you use the ampersand syntax & to string together your criteria. For this asterisk and parentheses syntax, using the '1' as the first for 'true' is critical. Microsoft Office documentation is always SO hard to sift online, so thanks so much for this video.
Very nice I did not know you could use the & symbol. Beats the hell out if my ifs combined with xlookup
What if your lookup value is an entire column of values?
ExcelSmith, It's been 2 months+. Do release more videos, more often.
Thank you for the support. Definitely working to release more videos.
Pls share with excerise attachment to me then i will be click thumb ups
Thanks for the comment. Here's the link to the Excel file: docs.google.com/spreadsheets/d/1pIVAr68qzGutgBfQquccwV_DiR0Lgs29/edit?usp=sharing&ouid=112840883257889972521&rtpof=true&sd=true