Linking Two Lists

M

Mark Philley

I want to take two seperate lists and create one list of each item combined
into one cell (or just beside each other). One list of departments and one
list of accounts. I want to have one list with each department listed with
each account.
Dept Account Combined
1 500 1-500
2 600 1-600
3 700 ...
4 800 ...
4-500
4-600
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column Heading on each row in pivot table 1
How identify data of two coulams,Every cell count and show result 1
How to dynamically add up varying # of cells base on a value 12
Comparing two lists 3
Formula so if reference is selected, a specific value is returned 1
Aligning Two Lists in Excel 2
Sort with IF functions? 5
Rank If - SumProduct - HELP PLEASE 1

Top