Hi I hope you excel geniuses can help.
I have some structural forces extracted from some design software to excel. The resulting spreadsheet contains multiple tables across 2 sheets.
Each table has a part mark for each beam, brace or column, the issue is that only one table contains the beam size. On sheet 1 column A contains the part mark and directly below this is the section size. the data I need that is missing this section size is on sheet 2. So I need to insert a new column on sheet 2 adjacent to the part mark, that looks for the matching part mark on sheet 1 and reports the value in the cell below (the section size) into the new column on sheet 2.
The data in sheet 1 follows a recurring pattern in that the section size is always directly below the part mark in column A. But there can be any number of blank cells or even new table headers before reaching the next part mark and section size. Currently I have to manually go through this process matching section sizes to part marks but it can take a day or more to go through this. I have tried lookups, transposition and IF's and I cant get the required results.
I have some structural forces extracted from some design software to excel. The resulting spreadsheet contains multiple tables across 2 sheets.
Each table has a part mark for each beam, brace or column, the issue is that only one table contains the beam size. On sheet 1 column A contains the part mark and directly below this is the section size. the data I need that is missing this section size is on sheet 2. So I need to insert a new column on sheet 2 adjacent to the part mark, that looks for the matching part mark on sheet 1 and reports the value in the cell below (the section size) into the new column on sheet 2.
The data in sheet 1 follows a recurring pattern in that the section size is always directly below the part mark in column A. But there can be any number of blank cells or even new table headers before reaching the next part mark and section size. Currently I have to manually go through this process matching section sizes to part marks but it can take a day or more to go through this. I have tried lookups, transposition and IF's and I cant get the required results.
