Table relationships in Excel?

  • Thread starter Thread starter saturnius
  • Start date Start date
S

saturnius

Hello,
I have an excel file exported from SQL server. There are two tables
1. User (columns: id, name, address, etc)
2. Tasks (columns: id, userid, description)

Is there a way to display the user NAME insead of the ID in the tasks table?
Many thanks in advance! Saturnius
 
You could do a vlookup on the linked field. If id is the same in both tables
use a vlookup function
 

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

Excel Table Relationships 3
Access Automatically Send a notification email once a record is added 0
Counting multiple memberships 1
Using Table Column for Data Validation List 2
group imported xml data according to keys 2
Link Cells (Read for more info) -- HELP PLEASE 2
PivotTables and Sum/Count 2 columns 2
Combining 2 tables 3

Back
Top