Solved

map the email address field in excel from all users sheets

Posted on 2016-11-18
2
11 Views
Last Modified: 2016-11-20
Hello,
I have a sheet that have 500 users and their data.
i got a column on another sheet that have 100 students.
i would like to put beside these 100 students (on the adjacent column) their email addresses that are existing in the all users sheet.
which function should i use for something like that ?
0
Comment
Question by:Da_Ch0sen
2 Comments
 
LVL 23

Accepted Solution

by:
Brian B earned 500 total points
ID: 41893660
That sounds like the VLOOKUP() function.

=vlookup(<data source>,<lookup range>,<column>,<exact>)

In this case <exact> would be false because you want to find an exact match. There is good detailed help in Excel.

If you have any problems, feel free to create an example of what you are doing and post it here.
0
 
LVL 6

Expert Comment

by:Michael
ID: 41894102
Or a combination of the functions INDEX and MATCH.
For the VLOOKUP function, the lookup value needs to be in a column left of the value you want to return, whereas with the INDEX / MATCH function the lookup value can be in any column.

For an example and explanation, check this link.

As Brian B said, if you post an example of your data, we could help you create a formula suited for your dataset.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

757 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now