VLOOKUP Loop to return multiple rows and columns

[5_Stripes_Fan]

Hi All,

I am looking for a solution to allow the below VLOOKUP code to loop and return all results in a table meeting the criteria in D2.. I have found several pages that have parts or other use case solutions but not one that fits issue this directly. Any help would be appreciated.

=IFERROR(VLOOKUP($D$2,Table1[#All],{3,5,6,7,8,9},FALSE),"")

This formula returns the data I need just need it to loop to other instances of the data in the table and return those as well. I know this can be done in VBA but I really need the VLOOKUP functionality as the lookup value will change daily. Any help is much appreciated.

 

[5_Stripes_Fan]

Also didn't mention this is for Excel 365

 

[Alex Blakenburg]

Since you seem to be indicating you would be happy to use 365 functionality, does this do what you want ?

=FILTER(INDEX(Table1, SEQUENCE(ROWS(Table1)), {3,5,6,7,8,9}),Table1[Col1]=$D$2,"")

Ref: FILTER Formula to Return Non-Adjacent Columns in Any Order - Excel Campus

 

[5_Stripes_Fan]

Was not able to get this formula to populate the data I needed, looks like it isn't liking the below referenced Table1[Col1] in the formula. I have attached an image of the sheet structure I am using hopefully this can provide more info on what I am working with. I also moved the D2 reference to D4 in the new sheet.

=FILTER(INDEX(Table1, SEQUENCE(ROWS(Table1)), {3,5,6,7,8,9}),Table1[Col1]=$D$4,"")

 

[Alex Blakenburg]

You need to replace “Col1” with what is in the heading row for the column you are comparing to D4.
I am guessing Rollout Date
eg
=FILTER(INDEX(Table1, SEQUENCE(ROWS(Table1)), {3,5,6,7,8,9}),Table1[Rollout Date]=$D$4,"")

 

[5_Stripes_Fan]

Works perfect, thank you.

 

[Alex Blakenburg]

Thanks for letting me know. Glad I could help.