selecting rows from search

%3CLINGO-SUB%20id%3D%22lingo-sub-1936497%22%20slang%3D%22en-US%22%3Eselecting%20rows%20from%20search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1936497%22%20slang%3D%22en-US%22%3E%3CP%3Ehey%20guys%2C%20I%20am%20trying%20to%20code%20a%20search%20of%20a%20cell%20value.%20I%20want%20to%20print%20in%20another%20sheet%20all%20the%20row%20results.%20i%20have%20used%20vlookup%20to%20find%20the%20result%20and%20countif%20for%20the%20number%20of%20rows%20but%20I%20can't%20get%20the%20rows%20in%20the%20new%20sheet.%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20assist%20me%20plz%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1936497%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1937634%22%20slang%3D%22en-US%22%3ERe%3A%20selecting%20rows%20from%20search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1937634%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F883739%22%20target%3D%22_blank%22%3E%40shawndotting%3C%2FA%3E%26nbsp%3BYou%20do%20not%20need%20to%20post%20your%20data%20if%20it%20is%20sensitive%2C%20but%20you%20may%20need%20to%20post%20the%20structure%20and%20we%20can%20provide%20you%20a%20better%20solution.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1938073%22%20slang%3D%22de-DE%22%3ESubject%3A%20selecting%20rows%20from%20search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1938073%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F883739%22%20target%3D%22_blank%22%3E%40shawndotting%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20if%20I%20can%20recommend%20you%2C%20add%20an%20MS%20Excel%20file%20(without%20sensitive%20data)%20to%20your%20project.%3C%2FP%3E%3CP%3EThere%20is%20no%20reason%20for%20the%20helper%20to%20want%20to%20reconstruct%20everything%20himself%2C%20what%20you%20basically%20already%20have.%3C%2FP%3E%3CP%3E*%20Knowing%20the%20Excel%20version%20and%20operating%20system%20would%20be%20an%20advantage.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1938769%22%20slang%3D%22en-US%22%3ERe%3A%20selecting%20rows%20from%20search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1938769%22%20slang%3D%22en-US%22%3EHere%E2%80%99s%20the%20file%20the%20issue%20is%20on%20customer%20access%20and%20customer%20results.%3CBR%20%2F%3EI%20already%20started%20but%20can%E2%80%99t%20populate%20the%20rows.%3CBR%20%2F%3EAppreciate%20the%20replies%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1938771%22%20slang%3D%22en-US%22%3EBetreff%3A%20selecting%20rows%20from%20search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1938771%22%20slang%3D%22en-US%22%3EThank%20you.%20Please%20see%20in%20my%20reply%20to%20Willy%20Lau.%20Appreciate%20you%20replying%20to%20my%20message%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1943286%22%20slang%3D%22en-US%22%3EBetreff%3A%20selecting%20rows%20from%20search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1943286%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20office%20365.%20Excel%202016%20I%20think.%20I%20have%20the%20xlookup%20option.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

hey guys, I am trying to code a search of a cell value. I want to print in another sheet all the row results. i have used vlookup to find the result and countif for the number of rows but I can't get the rows in the new sheet. 

Can anyone assist me plz? 

 

thank you

9 Replies

@shawndotting You do not need to post your data if it is sensitive, but you may need to post the structure and we can provide you a better solution.

@shawndotting 

With your permission, if I can recommend you, add a MS Excel file (without sensitive data) to your project.

There is no reason for the helper to want to reconstruct everything himself, what you basically already have.

* Knowing the Excel version and operating system would also be an advantage.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

Here’s the file the issue is on customer access and customer results.
I already started but can’t populate the rows.
Appreciate the replies
Thank you. Please see in my reply to Willy Lau. Appreciate you replying to my message

I am using office 365. Excel 2016 I think. I have the xlookup option.

@shawndotting Since you indicate to have XLOOKUP, you should also have FILTER. With this new function it is very easy to accomplish what you describe. With a slight redesign of the Customer Results sheet it could work as in the attached file. No need for VBA.

Nice.
Thank you.
I am going to try that. I was typing a code for each cell. Lol. Let me try that.
Ty

@Riny_van_Eekelen  holy snap your a God Sent....

 

than you thank you thank you

 

super easy in comparison to the codes I wrote,,,, index,,,min...if...row...column...

 

thank you 

@shawndotting Glad it worked out for you!!