How would I go about this with a match function for multiple sheets? This is the formula that I have: =IFERROR(IF(MATCH(B2,Sheet1!B:B,0), “Yes”,),”No”) I’m able to pull from sheet1. But how do I nest sheet2, sheet3, sheet4 with it ? Thank you for your help!!
I'm really impressed not only with the trick but the way you teach is simply Gr8.. Hat's Off
Brother you saved me, i had been looking all over, went through countless other similar videos but this was the one! Thank you stranger 🙏🏼
Mashallah,,,,,,,,,,,,,,,,,,,,,,,,,,sheet trick is amazing...............................
Thank you~🙏🙏🙏🙏😁😁😁😁😁😁😁😁
Excellent 👍
Awesome job
Sir, the same will work for excel 2010?
Yes it will work
nice job. please given the excel file in the description video
How would I go about this with a match function for multiple sheets? This is the formula that I have:
=IFERROR(IF(MATCH(B2,Sheet1!B:B,0), “Yes”,),”No”)
I’m able to pull from sheet1. But how do I nest sheet2, sheet3, sheet4 with it ?
Thank you for your help!!
why use + in front of indirect ?
I tried this on google sheet, it didn't work, can you help.. it says "an array value could not be found"
Excellent 👍