CODEWITHSUNDEEP
excel-formula
andy hilbert
andy hilbert

Reputation: 1

How do you align column values and keep the association of all columns to the right of column C with column C?

I am using =IF(ISNA(MATCH(A1,C:C,0)),"",INDEX(C:C,MATCH(A1,C:C,0))) to align column values, but I would like to keep the association of all columns to the right of column C with column C.

Upvotes: 0

Views: 266

Answers (1)

nbayly
nbayly

Reputation: 2167

If I understand you correctly you want to input the other corresponding columns from the first spreadsheet (Table1) to the matching rows on the second spreadsheet (Table2) by the ID number (Column C in Table1). I think you pretty much have the resolution in your first column with a little adaptation. In Table2 to output your subsequent column (ie column D from Table 1) have the following formulas:

=IF(ISNA(MATCH($A1,Table1!$C:$C,0)),"",INDEX(Table1!D:D,MATCH($A1,Table1!$C:$C,0)))

The same as your previous column but instead of outputting the ID number that you are matching to, it outputs the column next to it in the same row. You can then replicate this for as many columns as your first table has. Hope this is what you need. Cheers,

Upvotes: 0

Related Questions