FIND first different value in a series and produce corresponding value from another column

**Lemmy Kickit** · 11-22-2017, 02:26 PM

Did you follow all that? Yeah, me neither but that's precisely what I need and I've tried nearly every combination of FIND, MATCH, INDEX, and all of my other go-to's but to no avail. That's why I defer to your expertise to solve the following issue:

I'm looking for a formula that finds the first different value in column B for each value in column A, and produces the corresponding value in column C.

I feel like this is more easily demonstrated visually than verbally so I've attached a quick example that should make this way more comprehensible. Thank you so much in advance for your help!

**TMS** · 11-22-2017, 02:39 PM

In cell D2:

Formula:

Please Login or Register  to view this content.

and copy down. Filter column D for non blank and copy if required.

**63falcondude** · 11-22-2017, 03:06 PM

Try this in G30:

=INDEX(C$2:C$27,INDEX(MATCH(1,(A$2:A$27=F30)*(B$2:B$27<>VLOOKUP(F30,A$2:B$27,2,0)),0),0))

**Lemmy Kickit** · 11-22-2017, 05:23 PM

Originally Posted by TMS

In cell D2:

Formula:

Please Login or Register  to view this content.

and copy down. Filter column D for non blank and copy if required.

Dang, I hadn't considered going that route, thanks a lot for your help!

Originally Posted by 63falcondude

Try this in G30:

=INDEX(C$2:C$27,INDEX(MATCH(1,(A$2:A$27=F30)*(B$2:B$27<>VLOOKUP(F30,A$2:B$27,2,0)),0),0))

This is perfect, and makes me feel better that I was so close. Thank you also. Really appreciate the help, guys. Now I won't have to stay late the day before Thanksgiving haha.

**63falcondude** · 11-22-2017, 05:27 PM

You're welcome. Glad that we could help.

Enjoy your thanksgiving!

FIND first different value in a series and produce corresponding value from another column

LinkBack

Thread Tools

Rate This Thread

Display

FIND first different value in a series and produce corresponding value from another column

Re: FIND first different value in a series and produce corresponding value from another co

Re: FIND first different value in a series and produce corresponding value from another co

Re: FIND first different value in a series and produce corresponding value from another co

Re: FIND first different value in a series and produce corresponding value from another co

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Find Suitable sheet material to produce panel size

If att all possible in excel - find all linked cells in a matrix and produce a list

How do you fill a series of cell references and skip four to produce a sequence

How to Find Minimum Can Produce?

mixing column chart types for series and macro series?

produce a formulate to produce assigned seats for dinner

how do I change a line series to a column series in excel?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions