How do I sort two columns against one in Excel 2003?

I need to produce a method of moving the B and C columns to match up with A so:

with a macro or formula it should produce:

Column 1(A) should be unchanged but 2(B) and 3(C) moved; 2 and 3 will also need to be linked.

-

Adjust the range represented by B1:C11 in your top screen capture to reflect the range of B and C columns. Move the B & C column content to another location such as G1:H11

Then in B1

``````=IF(ISNA(VLOOKUP(A1,\$G\$1:\$H\$11,1,FALSE))=TRUE,"",VLOOKUP(A1,\$G\$1:\$H\$11,1,FALSE))
``````

and in C1

``````=IF(ISNA(VLOOKUP(A1,\$G\$1:\$H\$11,2,FALSE))=TRUE,"",VLOOKUP(A1,\$G\$1:\$H\$11,2,FALSE))
``````

you can always insert name define the range \$G\$1:\$H\$11 (or whatever it is) and use the namedRange in the formulas instead which would look like

``````=IF(ISNA(VLOOKUP(A1,namedRange,1,FALSE))=TRUE,"",VLOOKUP(A1,namedRange,1,FALSE))
``````

and

`````` =IF(ISNA(VLOOKUP(A1,namedRange,2,FALSE))=TRUE,"",VLOOKUP(A1,namedRange,2,FALSE))
``````

of course drag the formulas in B1 and C1 down adjacent to column A.

-
Brillant! Thank you very much, you saved my keyboard from a window excursion. – Chris Stein Jun 9 '11 at 7:39