LinkBack URL
About LinkBacks
Okay.. try using below formula:-
Formula:
=IF(ISERROR(MATCH($A3,HLOOKUP(D$1,Sheet2!$1:$4,{2,3,4},0),0)),"",1)
Enter this using ctrl shift enter key combination.. thanks.
example(1).xlsx
Regards,
DILIPandey
<click on below * if this helps>
Okay.. try using below formula:-
Formula:=IF(ISERROR(MATCH($A3,HLOOKUP(D$1,Sheet2!$1:$4,{2,3,4},0),0)),"",1)
Enter this using ctrl shift enter key combination.. thanks.
example(1).xlsx
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks