Excel 2003 - Match Column A with Column B Column C to correspond to Column B

Question

The title is confusing but here is exactly what I have and what I need to do:

Column A has a list of numbers.

Column B has the same list of numbers in a completely different order.

Column C has a list of numbers that correspond directly with Column B.

Column B needs to be sorted to match Column A and during the same sort, the contents of Column C need be moved to stay with Column B.

Any ideas?

Answer 1

Write a standard IF formula that compares the first two cells in Excel to compare two columns row by row. Copy the formula down to additional cells by dragging the fill handle to another column in the same row (a small square in the bottom-right corner of the selected cell). The cursor will change to a plus symbol as you proceed: