LinkBack URL
About LinkBacks
Alma 
I think this is what you are after. In S4:
=IF(INDEX('Sheet 2'!$C$3:$C$20,MATCH('Sheet 1'!P4,'Sheet 2'!$D$3:$D$20,0))=I4,"Amount Matched","Not Matched")
You can adjust the lengths of the arrays to suit your entire data set.
I think this is what you are after. In S4:
=IF(INDEX('Sheet 2'!$C$3:$C$20,MATCH('Sheet 1'!P4,'Sheet 2'!$D$3:$D$20,0))=I4,"Amount Matched","Not Matched")
You can adjust the lengths of the arrays to suit your entire data set.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks