Forum Discussion

Copper Contributor

Nov 27, 2020

selecting rows from search

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...

Formulas and Functions

NikolinoDE

Platinum Contributor

Nov 28, 2020

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)

shawndotting
Copper Contributor
Dec 01, 2020
I am using office 365. Excel 2016 I think. I have the xlookup option.
- Riny_van_Eekelen
  Platinum Contributor
  Dec 01, 2020
  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.
  Copy of Tag trials.xlsm215 KB
  - shawndotting
    Copper Contributor
    Dec 03, 2020
    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
Copper Contributor
Nov 29, 2020
Thank you. Please see in my reply to Willy Lau. Appreciate you replying to my message