Excel Vlookup / IF / Textbefore

ChrisRolando 

What I have in the first line of each set, a line with everything I need. However to bring this into another software I need to take the parts in the outlying columns, make them into line numbers using the Work Order reference and the part number to draw those numbers down into the columns.

Looks easy so far right?

No. In fact, what you've written doesn't really make sense. Your first sentence is not even a complete sentence (as your English teacher might tell you), although presumably it means the first line contains what you need...but need "for what" --that's not clear.  Nor does what follows--taking the parts in the outlying columns (what are they? can you be more precise?), make them into line numbers using .... etc. If you are going to use Excel to accomplish anything, or ask others to help you, you really need to slow down and describe things with a lot more clarity and precision.

Note the line numbers to the left. Note how they jump. This is caused by how this sheet is assembled from 12 tabs with inbound information.

The cause may be related to the inbound data from those 12 tabs, but there's nothing inherent in bringing data in from 12 tabs that requires line numbers to jump around randomly.

My main thought here, after looking at that image and seeing your description of the VLOOKUP formula you've tried, considering your thoughts on the use of a conditional (IF) function, etc.,  is that you (and your organization) would benefit greatly from stepping back and doing some thoughtful redesign before trying to make this work. It is just not designed in a way to support long term reliability. If anything, the difficulties you are experiencing is an example of what, even if you manage to get it to work this time, will remain--at best!--a spreadsheet that is next to impossible to reliably maintain, and is as a result liable to produce results that are themselves not to be relied on. You don't want that.

Would you be able to post a copy of the actual workbook--so long as it doesn't contain confidential or proprietary information--so that some of the Excel experts on this forum could take a look at it? You can post a copy (or a mockup devoid of confidential info) on OneDrive or GoogleDrive, pasting a link here that grants edit access to it.