I think I'm being a pain switching between the Offset and If/VLookup formula's but neither seem to be bringing up the information I'm asking it for.

In the case of the Offset formula, I think I've worked it out for the supplier details but Im unsure of how to drag it to the other cells for PO number, Sku, Description, etc. And it's not entirely bringing the correct information across. It's ignoring all the 'BM' supplier fields and just entering the 'EG' and 'MR' but they don't match to the corresponding Sku on the SZX file.

And while I thought the IF/Lookup was working, it just stops working half way down the file and I can't figure out why.

I would attach the excel files again but even compressed as a Zip they are 134kb. Is there anywhere else I could upload them to show you wants going on?

I'm going to be honest, I prefer using the If/VLookup because I actually understand that equation but if the Offset is the best to use, as long as it works I'm going to be upset!!

As always, help is very appreciated as I'm definitely going above my Excel Skillset!!