CODEWITHSUNDEEP
excelexcel-formula
AMDsupreme
AMDsupreme

Reputation: 1

vlookup next match or skip row

I am trying to get the next match in excel when using Vlookup or Index Match. I cant seem to skip results I already have. I cannot have a helper column because it is a database that is imported from access that I cannot change, and I can't have VB code (mainly because I don't know VB too well and I don't know how to use it in excel). Here is an example of what I want:

enter image description here

This is just an example. I have a database with hundreds of records from 50 teams that I don't really want to give out

Upvotes: 0

Views: 6360

Answers (1)

barry houdini
barry houdini

Reputation: 46341

Use this "array formula" in G4

=IFERROR(INDEX(B$2:B$100,SMALL(IF(A$2:A$100=G$1,ROW(A$2:A$100)-ROW(A$2)+1),ROWS(G$4:G4))),"")

comfiirmed with CTRL+SHIFT+ENTER and copied down as far as required and more. When qualifying values run out you get blanks

Adjust ranges as required

Upvotes: 1

Related Questions