Hi,
I have Sheet1 & sheet2
where I have to find value of Column C & D of Sheet1 which has to match with Column F & G of Sheet 2
I want result as duplicate in column E of Sheet1.
I need a formula only...
Thanks in advance
Hi,
I have Sheet1 & sheet2
where I have to find value of Column C & D of Sheet1 which has to match with Column F & G of Sheet 2
I want result as duplicate in column E of Sheet1.
I need a formula only...
Thanks in advance
I have used following formula & drag down
=IF(ISERROR(MATCH(C2&D2,Sheet2!$F$2:$F$258&Data!$G$2:$G$258,0)),"","Duplicate")
Press Ctrl+Shift+Enter
It works fine
thanks to everyone
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks