Forum Discussion
Formula Help
Working on a spreadsheet, trying to pull information from one tab to another. I have a bunch of raw data with part #'s as headings in column D, and the rest of the column is empty until the next part...
Here's an easier (I think) solution. Add a column (E perhaps), what we often call a "helper column" and populate each row with the part number using this formula, copied down. (This is assuming that D2 contains your first part number).
=IF(ISBLANK(D2),E1,D2)
That will populate the row with the applicable part number and make looking things up a lot easier.