Hi,

I have 5000 lines and 68 columns in a 2 page spreadsheet. The lines and
columns are the same, although in a different order on the 2 pages. how do I
lookup the data from sheet A and put it into sheet B against the same row and
column heading?

i.e
Sheet A
Customer West East South North
1000 10 10 10 10
2000 22 22 22 22
3000 30 30 30 30

Sheet B

Customer East North South West
3000
1000
2000


Thanks

Amanda