View Single Post
  #2   Report Post  
Adam
 
Posts: n/a
Default

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