Forum Discussion

shawndotting's avatar
shawndotting
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
shawndotting's avatar
shawndotting
Copper Contributor
Dec 01, 2020

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

Riny_van_Eekelen's avatar
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.

  • shawndotting's avatar
    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's avatar
    shawndotting
    Copper Contributor
    Dec 01, 2020
    Nice.
    Thank you.
    I am going to try that. I was typing a code for each cell. Lol. Let me try that.
    Ty

Resources