Excel guru wanted for =match formulae

I'm looking for some assistance with building a match formula in Excel.

Essentially I have two tables.

The first lists two columns a) product URL b) number sold (for 40 products for example)

The second table features two columns a) product URL and b) product category.

The 'first' table often includes lots of mispellings/variations, so I'd like to use an =match formular to be able to appropriately categorise these URLs.

When I look at the first table, I want to be able to pull in "sales by category".

To confirm, I don't want to use a vlookup on exact match, as there are simply too many URLs.

Instead, I'd like the formulate to count the first 10 categories, and try to match this against what is in the second table (the product categories.

I'm looking for a smart Excel freelancer, and I'd like to complete this task in the next 24 hours.