LinkBack URL
About LinkBacks
I'm having trouble coming up with a solution to my problem..I need to look up a specific Value in Cell "D1" in Worksheet 1, and return all the values that starts with the value in D1 in a data table pasted in column A in Worksheet 2.
I'm having trouble coming up with a solution to my problem..I need to look up a specific Value in Cell "D1" in Worksheet 1, and return all the values that starts with the value in D1 in a data table pasted in column A in Worksheet 2.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Basically, can you SHOW us the problem/need?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Activate Macro Recorder, do on Worksheet #2 a manual Find or better a filter and you will obtain a free new code !
Post it here and ask for what's missing, to be continued …
here's an example spreadsheet
You don't really need VBA. This ARRAY formula in B4 should work:
=IFERROR(INDEX(Sheet2!$A$1:$A$1000, SMALL(IF(ISNUMBER(SEARCH($D$1, Sheet2!$A$1:$A$1000)), ROW(Sheet2!$A$1:$A$1000),""), ROWS($A$1:$A1))), "")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Once the first value has correctly appeared and the array is active, copy B4 downward.
it's almost working...i got values in B4 but i don't think it searched the specific value in D1 because its giving me everything from the other sheet
Do you see the curly braces around the formula in B4?
http://screencast.com/t/jMEKrG6aAy
yes it is there
You can try the Attached file..
Formula:
Please Login or Register to view this content.
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
awesome! thanks everyone!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks