Thread: I'm trying to create a formula for an answer sheet.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ernesto Ernesto is offline
external usenet poster
  
Posts: 6
Default I'm trying to create a formula for an answer sheet.
I have John Smith and his associated number on 1 sheet. One the next sheet I
have a list of names and the next column over I want to automatically
populate with the number if John Smith appears.

Ex: John Smith 32311 Next Sheet: Angela Thomas
John Smith
32311

Reply With QuoteReply With Quote