Want to return value from 2nd column based on match in 1 field with first column

[lornagreenwood]

I'm working on a project in which I have 50 states + DC listed by 2-letter abbreviation, and want to return a value in another column that will be a non-unique number (some will duplicate in the second column.)

Also need to do this same operation with first column (state) and third column, which also is comprised of non-unique numbers.

Will anyone please help a user out? It seems simple, yet I don't know where to start.

Hlookup, lookup & pivot tables seem to not be a fit for this.

 

[c_m_s_jr]

You are getting the #REF! because you only have 1 column in your lookup range M. You will need to have it be $M$52:$N$102. The value you are looking up C2 must be in the first column of your look up range (Column M). Any value you want to return based on a match must have that column part of your look up range (i.e. Column N).

 

[lornagreenwood]

I didn't give the full range for the array - only Column M is shown

 

[lornagreenwood]

That fixed it - THANK YOU!!!