LinkBack URL
About LinkBacks
Hi Basing on the drop down list I am expecting the data to retrieve. I am attaching the file, kindly help me out
Sateesh
Hi Basing on the drop down list I am expecting the data to retrieve. I am attaching the file, kindly help me out
Sateesh
Enter this array formula in cell K7 and copy across
Formula:
Please Login or Register to view this content.
***Array formula
...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.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Try
=IFERROR(INDEX($B$4:$I$23,SMALL(IF(INDEX($B$4:$I$23,,MATCH($K$4,$B$3:$I$3,0))=$K$5,ROW($B$4:$B$23)-ROW($B$4)+1,""),ROWS($B$4:B4)),COLUMNS($A:A)),"")
Enter with Ctrl+Shift+Enter
Last edited by JohnTopley; 10-10-2016 at 09:29 AM.
Try for "wildcard" name ...
=IF($K$4="Name of the Candidate",IFERROR(INDEX($B$4:$I$23,SMALL(IF(LEFT($D$4:$D$23,LEN($K$5))=$K$5,ROW($B$4:$B$23)-ROW($B$4)+1,""),ROWS($B$4:B4)),COLUMNS($A:A)),""),IFERROR(INDEX($B$4:$I$23,SMALL(IF(INDEX($B$4:$I$23,,MATCH($K$4,$B$3:$I$3,0))=$K$5,ROW($B$4:$B$23)-ROW($B$4)+1,""),ROWS($B$4:B4)),COLUMNS($A:A)),""))
Enter with Ctrl+Shift+Enter
Last edited by JohnTopley; 10-10-2016 at 09:38 AM.
Re: Basing on the condition, needs to extract the data
Hi John Topley,
Awesome, it working. In addition to that can I go for the multiple search criteria.
If I add same drop down list in L4, do we get both condition accepted data.
Sateesh
Sir,
Its Working. Thanks for your time.
In addition to that can I go for the multiple search criteria.
If I add same drop down list in L4, do we get both condition accepted data.
Sateesh
If you want to have two or more conditions then you will need additional formulae.
Please post a file with your additional requirements for L4.
Hi
If I put the same drop down list selection criteria in L4 & search words with specific text which are mentioned in the attachment.
Kindly go through the attachment.
HI
sorry its
L4:L5 with M4:M5
Try
in L7
Enter with Ctrl+Shift+Enter
Please Login or Register to view this content.
Copy across and down
NOTE: the "wildcard" name MUST be in L5 i.e L4="Name of the Candidate"
Try this one
Formula:Please Login or Register to view this content.
See attached file
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks