| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data exctraction from multiple sheets | Excel Discussion (Misc queries) | |||
| create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
| Named Ranges | Excel Worksheet Functions | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| macro | Excel Discussion (Misc queries) | |||
Linear Mode
