need excel formula if then (i think)

[denny112]

Looking for a formula to identify a user’s primary location.

I receive an export of a user’s location from department “a” (this is the source of truth data) and I then run reports against these users and my report does not provide the same location name as department “a” provides me. There is an excel that say’s if Dept A return’s XYZ location then it’s XYZ location on my report. There is 42k paths to correlate so I want to see if there is a formula I can use to make it easier.

Example:
The data I received from department ‘A’ looks like this John Smith's primary location is \\home009\home005

The reports I run show me this location for John smith \\work0010\home001

I have a running spreadsheet that shows me if the location from dept “a” is \\home009\home005 then it would look like this \\work0010\home001 on my report that I run.

Also, the report I run has multiple locations for each user because they are backups of his primary location. I am trying to identify which one on my report is the primary depending on what comes back from Dept “a” and indicate yes or no.

Output i want to get to: Listed on my report John smith has 2 locations (listed below). Dept “a” returned location \\home009\home005 as primary and that matches up with \\work0010\home001. I want it to then indicate yes next to this location. I will have the running list of how the locations match up from the report i run & from dept "A" on another tab in the spreadsheet.

Name locations Primary (Yes or No)
Smith, john \\work0010\home001\smith, john yes
smith, john \\work010\home003\smith, john no

thanks!

[jeffreybrown]

Administrative Note:

Welcome to the forum.

We would love to help you with your query; however, the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[jeffreybrown]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread and you are allowed only ONE thread per issue.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...ml#post5300446