VLOOKUP help

Hi Guys,

First time poster, Beginner level excel skills.

Thanks in advance and bear with me through out the post.

- I'm wanting to use VLOOKUP across 2 sheets
- One sheet contains the names of employees, their team and which site they work from
- Second sheet contains feedback for certain employees from other employees within the business

I'm wanting to use VLOOKUP to search for a particular employee/team/site and its corresponding feedback.

Please let me know if you need more information.

Once again, thank you all in advance.

Hello and welcome to the forum. The key to matching formulas such as VLOOKUP or my favorite, INDEX MATCH, is to find a unique identifier in both data sets.

Sometime you will have to put together multiple non-unique identifiers to make a unique one (e.g. last name and location)

The best way for you to get the help that you need would be to create a small representative sample of your data along with the desired results of the formula (manually entered).

You can then upload that workbook directly to this forum through Go Advanced > Manage Attachments

Thanks for your time and expertise benishiryo and 63falcondude.

I've uploaded an example document.

Sheet1 contains the feedback, who it's from and who it's for (Sender and Recipient)
Sheet2 contains a list of employees and their relevant team and site.

To reiterate;

I'm wanting a function that allows me to search an employees name/team/site to bring up the corresponding feedback.

There may be an issue as Sheet1 does not label the employees team or site so the function would have to link the names of the employees with their team and site (hope that makes sense).

Thanks again.

An employee number is a perfect example of a unique identifier. Although I'm not sure where "Status", "Inactive Detail", or "Comments" are in Sheet1.

You didn't include the expected outcome of the formula.

In F2 of Sheet2, try this:

=INDEX(Sheet1!B:B,MATCH(A2,Sheet1!E:E,0))

Change B:B to whatever column you want to bring over from Sheet1.