I'm trying to create a formula for an answer sheet.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=VLOOKUP(A1,Sheet1!A1:B14,2,FALSE)

Pasted next to John smith where you want the answer to appear and wher A1 to
B14 are the 2 columns that contain your list of names and numbers
 

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

See if a range of cells contains certain text to return the value 3
Formula for names 6
Excel Linking Multiple cells to One cell for Results 0
Want a 3rd "results" sheet. 2
How can I count unique values 7
Cross reference two worksheets to identify matches 4
Trying to Find The Proper function 3
Excel 2

Back
Top