I am having a total brain melt down and am unsure of how to achieve the following:
I basically need a Yes/No function relating to whether text in D15 also appears on worksheet 'PO'!A1:A1000 - If it does, it says "Yes" in J15, if not it says "No" in J15
Something like this, which I know isn't a working formula!
=IF(D15='PO'!A1:A1000,Yes,No)
I'm running Excel 2003 if that helps at all
Thanks in advance
If it's an exact match either
=IF(ISNUMBER(MATCH(D15,PO!A1:A1000,0)),"Yes","No")
or
=IF(COUNTIF(PO!A1:A1000,D15),"Yes","No")
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Hi,
Try
Regards
Please Login or Register to view this content.
Last edited by DonkeyOte; 11-18-2009 at 08:32 AM. Reason: misplaced colon (reverted to comma)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
WOW! Thanks for the quick replies!
This one worked a treat:
=IF(ISNUMBER(MATCH(D15,PO!A1:A1000,0)),"Yes","No")
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks