Search for a text and then search for another text after the row containing the first text

**ajeshkdy** · 04-30-2021, 05:33 AM

Hello all,

I have attached a sample sheet to better understand my problem.

What I need is, search for "Location: KL" in column A of Sheet1 and then search for "Product 1" in the same column, but include only the cells after the text "Location: KL" in the search. Then get the "Product Quantity" value corresponding to "Product 1").

The formula is to be in B2 of Sheet2.

Any help is appreciated.

**NickyC** · 04-30-2021, 05:49 AM

There is probably a more elegant solution, but try this:

Formula:

Please Login or Register  to view this content.

**ajeshkdy** · 04-30-2021, 06:10 AM

Thanks for your help!

I adjusted your formula and finally got what I was looking for.

Formula:

Please Login or Register  to view this content.

Thanks once again!

Search for a text and then search for another text after the row containing the first text

LinkBack

Thread Tools

Rate This Thread

Display

Search for a text and then search for another text after the row containing the first text

Re: Search for a text and then search for another text after the row containing the first

Re: Search for a text and then search for another text after the row containing the first

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Search for text in a cell from a lookup table and return that text when a match is made

I want to search for text within a column & then search a range that depends on that text

VBA Code - Search text & search number & search qty and result - Urgent Please

IF(count(search) Function not working when search from text from a cell

Search cell for multiple text , return comma separated text in separate cell if found

[SOLVED] search for text, then search for previous text, replace 1st text including number from 2nd

[SOLVED] search a text cell CONTAINING matching text in a dynamic range (not exact match)

Bookmarks

Bookmarks

Posting Permissions