LinkBack URL
About LinkBacks
I need help to find number. I have used Vlookup function but it search only single number not repeated number.
help appreciated.find attached file
I need help to find number. I have used Vlookup function but it search only single number not repeated number.
help appreciated.find attached file
How many returns are you expecting? vlookup will only ever return the vvery 1st match it fionds.
In your sample WB, put this ARRAY formula in C4, then copy down and across as needed...
=IFERROR(INDEX(GaugeRack!C:C,SMALL(IF(GaugeRack!$C$3:$C$405=FindGauge!$B$4,ROW(GaugeRack!$C$3:$C$405)),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.
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
Is this what you were looking for?
Edit: I really need to remember to refresh b4 posting. FDibbins beat me again
Yes, Sir, this is it I was looking for , Perfect.
Thanks to all contributor and Admin.
I like this forum I got solution within few minutes.
You on Excel 2013
You can use Aggregate without using CTRL+SHIFT+ENTER!
C4Copy down and crossFormula:
=IFERROR(INDEX(GaugeRack!C:C,AGGREGATE(15,6,ROW(GaugeRack!$C$3:$C$405)/(GaugeRack!$C$3:$C$405=$B$4),ROW($A1))),"")
or
Copy down and cross.Formula:=IFERROR(INDEX(GaugeRack!C:C,SMALL(INDEX((GaugeRack!$C$3:$C$405=$B$4)*ROW(GaugeRack!C$3:C$405),0),COUNTIF(GaugeRack!$C$3:$C$405,"<>"&$B$4)+ROWS($4:4))),"")
Last edited by micope21; 12-13-2015 at 12:18 PM.
To help you by my post? it would be nice to click onto say "Thank you".
If you are happy with a solution to your problem?
Click Thread Tools above your first post,
select "Mark your thread as Solved".
Aggregate also working .
Thanks Sir.
Happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks