I have a data set with AD accounts and their AD path that inculudes city & country (ex: OU=New York,OU=USA,OU=Corporate... another one OU=Boston,OU=USA,OU=Corporate, etc..)
I have a separate data set with only the higher level OU's, ie per country, (ex: OU=USA,OU=Corporate.. another one OU=Mexico,OU=Corporate, etc.) with other data.
I needed to do a Vlookup in the 1st data set with the city/country combo... if it contains the "OU=Country,OU=Corporate" in the 2nd data set... bring back a column in the 2nd data set.
I've seen ways to look for partial vlookup matches with "*", but in the other direction, which would work if my 1st list had only Country, and the 2nd data set had City/Country.
Maybe Vlookup is not the way.. but am stumped so far.
Any ideas?
Thanks in advance.
I have a separate data set with only the higher level OU's, ie per country, (ex: OU=USA,OU=Corporate.. another one OU=Mexico,OU=Corporate, etc.) with other data.
I needed to do a Vlookup in the 1st data set with the city/country combo... if it contains the "OU=Country,OU=Corporate" in the 2nd data set... bring back a column in the 2nd data set.
I've seen ways to look for partial vlookup matches with "*", but in the other direction, which would work if my 1st list had only Country, and the 2nd data set had City/Country.
Maybe Vlookup is not the way.. but am stumped so far.
Any ideas?
Thanks in advance.