mercredi 1 août 2018

Excel match/index by column pair?

I am definitely a beginner when it comes to advanced Excel syntax. I tried searching for an answer to my question, but I may be too inexperienced to know how to look. Also possible I misspecified my title. Apologies if this has been answered previously.

Say I have the following 3 columns

     A            B            C
1    Alabama      Alabama      Red
2    Alaska       Wyoming      Blue 
3    Arizona      Alaska       Yellow
4    Arkansas     Florida      Green
5    California   Arkansas     Black

And I want to produce a list of same-row B/C pairs that have B values equal to A values:

     D            E
1    Alabama      Red
2    Alaska       Yellow
3    Arkansas     Black

How can I do this?

Thank you thank you thank!

Aucun commentaire:

Enregistrer un commentaire