LinkBack URL
About LinkBacks
Jean Claude Baptiste 
You're welcome. Thanks for the feedback.
A slightly shorter version of the same formula.
=IFERROR(INDEX('Source A'!E:E,MATCH(O1,'Source A'!F:F,0)),
IFERROR(INDEX('Source B'!J:J,MATCH(O1,'Source B'!K:K,0)),"No Match"))
You're welcome. Thanks for the feedback.
A slightly shorter version of the same formula.
=IFERROR(INDEX('Source A'!E:E,MATCH(O1,'Source A'!F:F,0)),
IFERROR(INDEX('Source B'!J:J,MATCH(O1,'Source B'!K:K,0)),"No Match"))
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks