I have attached a link to the spreadsheet I am referring to:- https://www.dropbox.com/s/i5lvozes381hj18/Test Scan Mr.Excel.xlsm?dl=0

If the part from A1 "XPGLIDE" matches F3 then I want N3 to populate the same as A3, but the rest of K3 through to Z3 to return Zero.

Similar if A1 was changed to "25412AYERSROOF." and F4 matches the part "ROOF" then I want to populate X4 the same as A4 but the rest of K3 through to Z3 to return Zero.

As you can see from the spreadsheet there are 16 different variations (see row 1) that could possibly be in column F and hence could be in A1.

The formula in N3 is something I thought would work but unfortunately is not.

If there is a match I then need the same cell to populate the difference between cells AF and AI.

I hope this makes sense when you look at the spreadsheet.

I have googled and tried different various ways but I am at a dead end.

I hope one of you helpful people can help resolve this for me.

Thanks in advance.