Excel lookup question

Question

I have a sheet with a location # and other information listed, I have a second sheet with all users, title and location #

I am looking to have Sheet 1 show me who the manager is for that specific location based on sheet 2.

So I have to look up the location on sheet 1 and return only the manager's name from sheet 2

I am sure this is a simple lookup but have not been able to get it to work.

Answer 1

Hi Brian Galloway1,

Thanks for your valuable feedback and I appreciate your kind words.

Also, if possible, if you find our suggestions helpful, you can also use the feedback tool below our reply to submit your feedback for us (pictured below).

If there is any issue related with the Office applications in the future, please feel free to post back in this community.

We will be here for help.

Have a good day and stay safe 😊

Best wishes

Waqas Muhammad

Answer 2

Thank you this is perfect and gives me a change to look at other ways to do things than I was thinking...

Great help

Answer 3

Hi Brian Galloway1,

Thanks for your valuable feedback and sharing updates with us and I really appreciate your effort and your precious time doing.

And I appreciate your kind words.

=IFERROR(INDEX(Sheet2!A:A, MATCH(1, (Sheet2!C:C = A2) * (Sheet2!B:B = "manager"), 0)), "Not Found")

 Sheet 1:

Sheet 2:

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Sincerely,

Waqas Muhammad

Answer 4

thank you for your response,

Sheet 1 has the location only listed once

the sheet 2 the location listed several times because there are several people in the same location with different titles and I am only looking to display only the one that has "Manager" in the title

Answer 5

Dear respected Brian Galloway1,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, here is sample formula:

Assumptions:

Sheet1 has the location numbers in Column A, and you want to return the manager's name in Column B.

Sheet2 has the location numbers in Column A, user titles in Column B, and manager names in Column C.

In Sheet1, go to cell B2 (or wherever you want to place the manager's name) and enter this formula:

=VLOOKUP(A2, Sheet2!A:C, 3, FALSE)

If there is any misunderstanding, I apologize and if it is convenient for you, could you please send copy of your document file to me so that I can look from my side, and I will check this behavior and help you to fix and verify the result with you.

If there is confidential information, then you can send it to me in Private Message(PM). you can access PM from the top right corner of this page, as shown in image below:

Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution.

I'm sorry and I apologize for that.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad