LinkBack URL
About LinkBacks
Hello
Try this formula
D1 =IF(SUMPRODUCT((C1=Sheet2!A1:C100)*TRUE())>0,"Match","")
and copy down
If it doesn't work then please attach a sample workbook of your data
Hope this helps!!
Hello
Try this formula
D1 =IF(SUMPRODUCT((C1=Sheet2!A1:C100)*TRUE())>0,"Match","")
and copy down
If it doesn't work then please attach a sample workbook of your data
Hope this helps!!
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks