Return next matching value

%3CLINGO-SUB%20id%3D%22lingo-sub-2583909%22%20slang%3D%22en-US%22%3EReturn%20next%20matching%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2583909%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%20I%20am%20struggled%20with%20finding%20a%20way%20to%20solve%20the%20below%20problem%3A%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%221%22%20width%3D%2241.58955456627108%25%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%229.375350873909952%25%22%20height%3D%2230px%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2221.75324675324675%25%22%20height%3D%2230px%22%3E%3CSTRONG%3E%3CFONT%20color%3D%22%23000000%22%3EA%3C%2FFONT%3E%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2281.8677709275136%25%22%3E%3CSTRONG%3E%3CFONT%20color%3D%22%23000000%22%3EBurger%3C%2FFONT%3E%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%229.375350873909952%25%22%20height%3D%2230px%22%3E2%3C%2FTD%3E%3CTD%20width%3D%2221.75324675324675%25%22%20height%3D%2230px%22%3EA%3C%2FTD%3E%3CTD%20width%3D%2281.8677709275136%25%22%3ECheese%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%229.375350873909952%25%22%20height%3D%2230px%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2221.75324675324675%25%22%20height%3D%2230px%22%3EA%3C%2FTD%3E%3CTD%20width%3D%2281.8677709275136%25%22%3EFries%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%229.375350873909952%25%22%20height%3D%2230px%22%3E4%3C%2FTD%3E%3CTD%20width%3D%2221.75324675324675%25%22%20height%3D%2230px%22%3EA%3C%2FTD%3E%3CTD%20width%3D%2281.8677709275136%25%22%3ECoke%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%229.375350873909952%25%22%20height%3D%2230px%22%3E5%3C%2FTD%3E%3CTD%20width%3D%2221.75324675324675%25%22%20height%3D%2230px%22%3E%3CSTRONG%3EB%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2281.8677709275136%25%22%3E%3CSTRONG%3ENando's%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%229.375350873909952%25%22%20height%3D%2230px%22%3E6%3C%2FTD%3E%3CTD%20width%3D%2221.75324675324675%25%22%20height%3D%2230px%22%3EB%3C%2FTD%3E%3CTD%20width%3D%2281.8677709275136%25%22%3ESprite%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%229.375350873909952%25%22%20height%3D%2230px%22%3E7%3C%2FTD%3E%3CTD%20width%3D%2221.75324675324675%25%22%20height%3D%2230px%22%3E%3CSTRONG%3EA%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2281.8677709275136%25%22%3E%3CSTRONG%3ESteak%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3ELet%20say%20we%20have%20%3CSTRONG%3E5%3C%2FSTRONG%3E%3CSTRONG%3E%26nbsp%3BA%3C%2FSTRONG%3E%20and%20%3CSTRONG%3E2%20B%3C%2FSTRONG%3E%20formatted%20in%20this%20order.%3C%2FLI%3E%3CLI%3EI%20wanted%20to%20build%20a%20formula%20that%20returns%20me%20the%20value%26nbsp%3B%3CSTRONG%3EBurger%3C%2FSTRONG%3E%20and%20%3CSTRONG%3ENando's%20%3C%2FSTRONG%3Ein%20column%20C%26nbsp%3Bby%20searching%20for%20%3CSTRONG%3E1st%20A%3C%2FSTRONG%3E%20and%26nbsp%3B%3CSTRONG%3E1st%20B%3C%2FSTRONG%3E%20in%20column%20B.%20Then%20it%20will%20continue%20to%20locate%20the%3CSTRONG%3E%20next%20A%20(or%20C%2C%20D%2C%20E)%3C%2FSTRONG%3E.%26nbsp%3B%3C%2FLI%3E%3CLI%3EIs%20it%20not%20enough%20just%20using%20IF%2C%20AND%2C%20VLOOKUP%20formula%20to%20create%20this%20logic%3F%20Or%20programming%20a%20VBA%20for%20this%20would%20be%20required%3F%26nbsp%3B%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2583909%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2587435%22%20slang%3D%22en-US%22%3ERe%3A%20Return%20next%20matching%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2587435%22%20slang%3D%22en-US%22%3ECheck%20out%20the%20FILTER%20function.%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi everyone, I am struggled with finding a way to solve the below problem: 

1ABurger
2ACheese
3AFries
4ACoke
5BNando's
6BSprite
7ASteak

 

  • Let say we have 5 A and 2 B formatted in this order.
  • I wanted to build a formula that returns me the value Burger and Nando's in column C by searching for 1st A and 1st B in column B. Then it will continue to locate the next A (or C, D, E)
  • Is it not enough just using IF, AND, VLOOKUP formula to create this logic? Or programming a VBA for this would be required? 
2 Replies
Check out the FILTER function.

@chunhoj1717 

Couldn't get it out of my head and keep going since I've seen the problem

... it was so easy, hard ... for me :)).
I got this VBA code for the dropdown menu from the Internet,

I just don't know from where or whether I put it together, otherwise I would have liked to put the link at, unfortunately ... I'm getting old Everything else is manual work.

 

You can find an example in the inserted file.

 

Hope this approach helps you ... because I don't have another one :).

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.