IF Formula Associations

[Larkin.usmc]

Good Morning Excel Gurus!

I'm currently working on an excel spreadsheet and can't seem to create the proper IF formula for column associations.

I'm trying to have the Organization (Column A) associated with the Organization code (Column C)

The second excel tab contains the Organization and it's matching code.

Please let me know if you can offer any ideas, I've attached an example of what I'm working with.


Thank you in advance for your assistance!

[AlKey]

Please see attached file with formula in A2

[smb_146]

use this formula in Cell A2 and copy it down

=INDEX(Sheet2!$A:$B,MATCH(C2,Sheet2!$B:$B,0),1)

[Larkin.usmc]

Perfect! This is exactly what I was having an issue with.

Thanks again, can't express how much this helps!

[AlKey]

You're welcome. Don't forget to thank those who helped by clicking on Add Reputation *