I run a macros that searches for strings in emails and then compiles a 2 column list. The list has names and prices which are supposed to be used in a vlookup on the main page to return price matches for exact match names. The vlookup wont work despite exact matches. When I manually add a name to the list and add a fake price, it will work and returns the value. But it won't work with these strings. Ive tried removing all spaces and that didnt work either.

TestVlookupWorkbook.xlsx

There is a test file. The first page is a sample accounting spreadsheet, the vlookup is in column F, the second sheet, "Sheet 1" has all of the names and the corresponding cost info. I hardcoded a name and fake cost amt at the end of the list in red on sheet1 and that worked...

The macros aren't included...

Can't figure out WHY this vlookup wont work....