Forum Discussion
Solved
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 fu...
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?
I am sending an example through One Drive.
I'm afraid screenshots aren't very useful. I repeat the request in my previous reply.