Hi All!
Please help!
I've two sheets containing Incoming and Outgoing data. On the Outgoing Sheet, the Reply ref. shows the corresponding Incoming document replied for. I want to have the Reply Document ref. on the Incoming sheet corresponding to the document replied.
I've attached a sample sheet
Regards
Akbar
welcome to the forum, Akbar. try in B2:
=IFERROR(INDEX(Outgoing!A:A,MATCH(A2,Outgoing!B:B,0)),"")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
just copyed column a to column c in outgoing sheet and made vlookup in incoming sheet
pls check attached 4 ur help
Thanks for your reply. it is comes up with #NAME? ERROR.
Thanks
Re: Comparing two columns in two different sheets and get the common in the first sheet
Hi Vijay
Thanks. it works. thanks for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks