Linking 2 Sheets

Pam Parrish

I have 2 Sheets the First Sheet shows All accounts (which is unique) the 2nd sheet may or may not contain all accounts but each account has multiple values (rows). How can I add the multiple values into the first sheet?

Basically the 1st sheet will have to expand rows.

Gia Thinh

Can you post screen shots of the two sheet (hide sensitive info) ?

Andrée Starå

Hi @Pam Parrish

I hope you're well and safe!

You could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Pam Parrish

I am attaching a sample 'lookup' sheet and a sample 'update' sheet as to what I need it to do. Hope this helps.

Lookup Sample.xlsx

Update Sheet.xlsx