Matching numbers (Excel 2003)

Topic

New Reply

I have 2 sets of data A2:D10 and G2:J10. I need the 2nd set to be rearranged like the first set. See Rows 14 to 22. That’s how i need it to turn out. Is it possible to do this with formulas? Thanks

Reply | Quote

Replies

Paste the following formula into cell G14; then select G14:J22. Fill Down and finally Fill Across.

=INDEX(G$2:G$10,MATCH($A14,$G$2:$G$10,0))

H.T.H.

Reply | Quote

Select A14, enter the formula and copy across to J14,
then, select A14:J14 , and copy down to A22:J22

=IF(A2″”,INDEX($A$2:$J$10,MATCH(IF(COLUMN(A:A)<8,$A2,$G14),IF(COLUMN(A:A)<5,$A$2:$A$10,$G$2:$G$10),0),COLUMN(A:A)),"")

Regards
Bosco

Reply | Quote