• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 66
  • Last Modified:

need help with query in excel that uses a results list to pull entries from a master list

I get a results list from an e-mail campaign we are running that shows activity. I need to use this results list that just shows e-mail addresses (column A) to pull the entire row entry from a separate master list that has multiple columns of information (columns A-U) on a different sheet and output that to a different workbook, or sort it so I can cut/paste to a different workbook.
0
ADJ-admin
Asked:
ADJ-admin
  • 2
  • 2
1 Solution
 
OnisanCommented:
Sounds like a Vlookup Function here's an example
I have your Results list as one tab (just Emails)
a Master list as one tab (lots of details)
Finally the End Results Tab with the formulas in them to show how to pull back data from the other two tabs

So in the End Results Tab, the first column just gets the email addresses from the Results tab
Then the next column Column B says  Look in the Master List columns A through to U and get me column 2 where the address in column 1 is the same as my column 1
You will see that all you need to do is copy the formula along to column U and change the third perameter in the formula to the next column number as you go. Dragging the formula don the sheet will not need any changes, same goes for column 1 just drag down.
0
 
OnisanCommented:
I can't see the attachment so here it is again
Example.xlsb
0
 
ADJ-adminAuthor Commented:
That did the trick, thank you very much!
0
 
ADJ-adminAuthor Commented:
Did exactly what I needed!
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now