Merging data from 2 data sets

[hand5841]

Hi,

Have spent a while trying to figure out a non manual solution to my "challenge". I thought it would be simple, but have a mental block.
Not sure whether it is a table,pivot,formulae,array or vba solution. I can't get pivots or tables to work and tbh this would be my preferred method in this instance.

I have a list of Fixed Assets with Fixed Asset numbers, I have a list of counted assets, some with assigned sticker numbers, some without (not required).
The Fixed Asset numbers are different from the sticker numbers.

I need to assign the sticker numbers to each asset number based on the asset type.

(The primary key in both lists is the asset type, of which there are about about 322 types (the same) for both lists, with each list containing 20,000 lines of data (roughly) in each list.

I can't just copy and paste the the 2 lists next to each other (Fixed Asset list and the count list) because the number of lines (qty of assets) is not the same for each list of asset types, so the tables will not align or be grouped by asset type. ie the number of "chairs" on the fixed asset list may be more than the number counted.

Was hoping by the time I had written this I would have figured it out....
Any help gratefully received.