Thread: List of Id's in one Colum list of names in another. More Id's on s
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default List of Id's in one Colum list of names in another. More Id's ons
You can do this using VLOOKUP - described in Excel Help.

Pete

On Nov 6, 12:45*pm, Willciti
wrote:
I have a colum with a list of ID's and another with a list the corresponding
names.
The rest of the spreadsheet has colums of the same Id's. I was hoping to use
a formula like (=if the user id match's another user id then in the colum
next to the id paste in the name from colum 2

Reply With QuoteReply With Quote