Solved

Excel List Question

Posted on 2011-02-24
7
276 Views
Last Modified: 2012-05-11
Apologies for the newbie question, but can't seem to find what should be a fairly easy task in excel:

I have two reports, Report A is a list of all users and all computers. Report B is a subset of users, all I want to do is use the list of names in B ro retrieve their corresponding computer name from A. So basically refine list A using criteria from list B...

Thanks
0
Comment
Question by:Leavert
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 34975343
If Report A is on a sheet called that with users in A2 dowm and computers in B2 down then you can use VLOOKUP.

In Report B if you have users in C2 down then use this formula in D2 to retrieve the computer name

=VLOOKUP(C2,'Report A'!A$2:B$1000,2,0)

regards, barry
0
 
LVL 33

Expert Comment

by:jppinto
ID: 34975368
Here's a simple explanation on the use of the SUMPRODUCT() function:

http://excel-user.blogspot.com/2009/10/vlookup-get-value-based-on-another.html

jppinto
0
 
LVL 50
ID: 34975386
@jppinto, how would sumproduct retrieve a text value?
0
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 
LVL 33

Expert Comment

by:jppinto
ID: 34975403
LOLOL I was thinking on VLOOKUP() and I wrote SUMPRODUCT!!! Sorry for the typo...

That's what happens when we're multi-tasking! :)
0
 

Author Comment

by:Leavert
ID: 35206013
Fine by me, thanks
0
 
LVL 24

Expert Comment

by:broomee9
ID: 35225358
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question