I have Sheet 1 with columns: A-Date, B-Region, C-Caption (1-2 sentences).
Sheet 2 has columns: A-Date, B-Region, C-Caption, D-Legal Practice.
I need the data from cells in SHEET2 Column D inserted into SHEET1 based on SHEET1's columns A,B,C matching SHEET2's A,B,C.
Thank you for any and all help.
Example.xls
Hi
Welcome to forum
Sheet1 Cell D1 =IFERROR(INDEX(Sheet2!$D$1:$D$100,MATCH(1,(A1=Sheet2!$A$1:$A$100)*(B1=Sheet2!$B$1:$B$100)*(C1=Sheet2!$C$1:$C$100),0)),"None!") Control+Shift+Enter then copy down.
You will get some None!
To help you by my post? it would be nice to click onto say "Thank you".
If you are happy with a solution to your problem?
Click Thread Tools above your first post,
select "Mark your thread as Solved".
micope... You the man! or woman! either way --- thanks very much. That's a heckofa formula and it worked like a charm. Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks