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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - I'm trying to create a formula for an answer sheet. (https://www.excelbanter.com/excel-worksheet-functions/129842-im-trying-create-formula-answer-sheet.html)

Ernesto

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

Mike

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

=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

"Ernesto" wrote:

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

All times are GMT +1. The time now is 07:11 PM.