Hey guys, I'm hoping you can help with this. I have a range from k4 to
p203 that I need to sort so that it matches another range b4 to d291.
The common between the two is U.S cities in the b and L columns.
The range from b4 to d291 has to remain exactly as it is. the rowa in
k4 to p203 need to move up and down to match the other range. There are
also multiple occurances of some cities in the b and l columns, and
there are a few blanks(no city) in the b column. Any ideas how to
accomplish this?
My best guess is this is an offset match or a vlookup. Please send some
suggestions you guys are a lot better at excel than I am. thanks! steveo