Forum Discussion
Automated pull from different worksheet within the same workbook
I'm looking to be able to pull data from a different worksheet within the same workbook. I want to be able to type in a cell on Sheet 1 and have it pull the one with the same name from Sheet 2(and full name even if I put in part of a name on Sheet 1) and fill in data into the next cell with it automatically from a linked cell on Sheet 2. Ex. I have a list of names (first and last in column 1, Sheet 2) and phone numbers (column 2, Sheet 2). How can I select a cell in Column 1, Sheet 1 and type just "Dan", get the few Dan selections from Sheet 2 auto-drop down and auto fill in Column 2, Sheet 1 with the correct associated phone number. Apologies for this being a confusingly written.
Here you go.
Let's say you enter (part of) a name in A2 on Sheet 1.
Enter the following formula in B2:
=FILTER('Sheet 2'!B:B, ISNUMBER(SEARCH(A2, 'Sheet 2'!A:A)), "- no match -")
Replace Sheet 2 with the real name of that sheet.
- This only returned a value of "0" for me. I have no data linked yet for the name into A2 from Sheet 2 yet (if that needs to be done). I tried with typing the entire correct name into A2 before entering this formula into B2.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
