VLOOKUPS, MID, AND FIND Together Returning Last Cell in Array

Hello,

I'm new to the site, so thank you in advance for your help.

I've got a workbook that I'm not allowed to share, and I'm trying to match some data from one worksheet to another.

On Worksheet1, I have 40,000 entries that contain information about advertisements for 49 different url addresses, each with a unique identifier embedded in the url. On Worksheet2, I have the 49 url addresses and the respective advertising campaigns that each belongs to (e.g. "Ad Campaign 1, Ad Campaign 2, ...)

I am trying to show which campaign each of the 40,000 ads/url's belongs to. I used a combination of MID & FIND to extract the unique identifier. I did this because each url was a different length, plus the ID was always followed by "|" and contained eight characters (text and numbers).

Next, in Worksheet1 I tried to use =VLOOKUPS(L22,'Worksheet2'!A2:B50,1,FALSE)

L22 is a cell that contains the MID & FIND formulas to parse the unique identifier from the url in the same row.

For some reason, the FALSE in my VLOOKUPS never returned anything, but the TRUE would return the last cell in the array. Please help!! I've searched the web and asked everyone I know.

Thank you!

If the values in column A are not sorted in ascending order, which is necessary with that last true/false argument. Try using index-match:

=INDEX('Worksheet2'!$B$2:$B$50,MATCH(L22,$A$2:$A$50,0))

(look for L22 in column A and return the corresponding value from column B)

If this doesn't work, post a short exemplary workbook or give more detail about how your data is organized.

Hey! Thanks for the response. I'm trying to get and exact match. It does exist, but I think it might be confused, because I am extracting the ID from the URL's with MID functions in the array i'm trying to match, and in Column L.

So my formula doesn't work? It will be hard to assist further without seeing a workbook.

Here are screenshots of what's going on. Sorry, I got carried away trying to hide the sensitive data

So you want values from the Campaign column on Analysis to go to the Campaign column on Table?

=INDEX('Excel Table'!$A$2:$A$50,MATCH(L22,'Excel Table'!$B$2:$B$50,0))

Oh, thank god!!! You are truly a lifesaver!! I've spent about six hours researching online, and I even went to all of my professors, but I wasn't able to figure it out until now. Thank you.

Yeah, you just had your references backwards.

INDEX(List where your desired values will come from,MATCH(The item you're looking for, List of items that corresponds with desired value,0))