First of all, thank you for helping me solve this one.
I am building an excel document that needs to gather data from another excel document. I want it to find a specific name, ie Charles, and return values from the adjacent column.
Charles 23
Jason 37
David 45
Charles 64
Sam 25
So, in this situation I would want to see both values, 23 and 64
Add filter in first row and filter out any name you like.
Hello princecanthony,
Welcome to the Forum!
Is this document an Excel workbook?
Is the data your are searching for in the same workbook?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Yes it's an Excel workbook. It is a different file that I want my current file to lookup
Helloo? Could I get a little help please?
hello and welcome to the forum
1st, let me point out that ALL members here are volunteers and offer their help as and when they can. If you are in a hurry for help, I suggest you take a look at our Commercial Services forum, where, for a fee, you will get quicker help.
On the sheet where your data is, use this in a helper column, copied down (I used C)
=A1&COUNTIF($A$1:A1,A1)
It will look like this...
Charles Charles1 Jason Jason1 David David1 Charles Charles2 Sam Sam1
Then in the workbook where you want the answers, use this, copied down...
=IFERROR(INDEX('[file1.xlsm]Sheet1'!A$1:B$5,MATCH($A$1&ROW(A1),'[file1.xlsm]Sheet1'!C$1:C$5,0),2),"")
with "Charles" in A1
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sorry I am on a deadline for this excel document... But thank you so much!!! You're a lifesaver
I don't know if this is possible, but a shot in the dark; If the document that my current excel file searches doesn't return any more Charleses, could it search a second file?
hmm well maybe try this...
=IFERROR(INDEX('[file1.xlsm]Sheet1'!A$1:B$5,MATCH($A$1&ROW(A1),'[file1.xlsm]Sheet1'!C$1:C$5,0),2),IFERROR(INDEX('[file1.xlsm]Sheet1'!A$1:B$5,MATCH($A$1&ROW(A1),'[file1.xlsm]Sheet1'!C$1:C$5,0),2)"")).
(untested)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks