Returning a cell value that matches from a field associated with another field

[texasaggie0004]

Hello all,

I hope I can explain this well, I've attached a super summary example of what I'm working with. I've got a list of houses in a study area I am working on - each house is associated with a build year and subdivision name. I'm trying to arrange the subdivisions in order of earliest house built inside that subdivision. If I sort merely by house built year - the subdivisions won't be clustered together as each subdivision may have houses built later than other subdivisions.

1st thing I've done is sort the full list by house build year. 2nd, I copy pasted the subdivision name column and then "removed duplicates" - which left me with a list of the subdivisions in order of earliest house built.

I would like to take that truncated list and associate a number to the longer list so that when I sort the longer list I can sort by the number - which would cluster the subdivisions by order of earliest built house.

I hope that's understandable. The attached list has only 20 examples on it whereas my study area in my actual excel sheet has several thousand. There are several hundred subdivisions also which I why I'd rather not do a manual "Find and Replace".

Is there a formula or method to assign a value to a cell if a cell associated with the target cell matches conditions found in two separate columns?

Thanks in advance!

[ELeGault]

If your intent is to assign the value associated to the SubDivision then you can lookup the subD from E to F and return what is in the second column of the reference..so F.. to get the values you want.

Place this formula in C2 and then copy the formula down the entire list (Drag it down)

Please Login or Register  to view this content.

[texasaggie0004]

Thanks! That works.

[ELeGault]

Perfect - be sure to mark this "Solved" under thread tools on your original post