Microsoft Office Forums - View Single Post - [Solved] Formula using If and AND

Thread: [Solved] Formula using If and AND

View Single Post

Old

10-15-2021, 02:39 PM

14spar15

14spar15 is offline

14spar15 uses Windows 7 64bit

Windows 7 64bit 14spar15 uses Office 2010 64bit

14spar15 uses Office 2010 64bit

Office 2010 64bit

Advanced Beginner

The original poster

Join Date: Mar 2011

Posts: 97

14spar15 is on a distinguished road

Default

I found something that seems to work. =IF(AND(ISNUMBER(SEARCH(I$2,B3)),D3=J$2), C3,"") Thank-You

Reply With Quote