Table relationships in Excel?
 

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

"saturnius" wrote:

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

Maybe =vlookup() or =index(match()).

Visit Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html
and
http://www.contextures.com/xlFunctions03.html

for some nice instructions.




saturnius wrote:

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

--

Dave Peterson