I am trying to match the persons last names to the company names in another workbook. Id also need the phone number and title to match up. I cant seem to get the formula correct though. Here is the 1st workbook where i need the information to be (http://imgur.com/a/v3JuX) here is where i am getting the data from ( http://imgur.com/a/pYOv8 ) ( Name is TPS)
I need all of the information that is alike to transfer correctly.
Edit: If someone could TW with me.. Id be greatful for the help Thanks
Hi and welcome to the forum
Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.
Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.
Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thannks for the reply
To be honest as of right now I do not have a first step done yet. I am having problems using the index formula
Yes i have but it does not help me out since I have multiple criteria and the data is in different workbooks.
So like alansidman said above: attach sample wokbooks , not a pictures
I need the information in book 2 and the data is in book3. I hope that is can help out more. As I am really having problems with this
change format in Book2 column E to General not a Text
Paste to E2: =IFNA(INDEX([Book3.xlsx]Sheet1!A$2:A$5,MATCH(C2,[Book3.xlsx]Sheet1!$E$2:$E$5,0)),"") and drag down
both files should be opened, however it should work with Book3 closed
Last edited by sandy666; 06-11-2017 at 08:09 PM. Reason: typo
That works for the companies, how would i apply it for the Email and Phone number,fax,title?
Thanks!
change index range accordingly
also you can try with
=IFNA(INDEX([Book3.xlsx]Sheet1!A:A,MATCH($C2,[Book3.xlsx]Sheet1!$E:$E,0)),"")
and change only red range suitable to your needs
but this is not my favorite solution. I prefer defined range, like $A$2:$A$1000 than undefined like A:A
or
=IFNA(INDEX([Book3.xlsx]Sheet1!$A:$G,MATCH($C2,[Book3.xlsx]Sheet1!$E:$E,0),1),"")
where $A:$G is a range of your full table from Book3, and 1 is a number of column in your Book3 table. In this case no. 1 is the first column (A:A), 2 (B:B) etc.
so will be enoug if you will change only this number to retrive suitable data
If that takes care of your original question, please click Add Reputation and select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Last edited by sandy666; 06-11-2017 at 09:34 PM.
At the risk of going...oh, DUH...
what is TW?Edit: If someone could TW with me.. Id be greatful for the help Thanks
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks