Lookup by row and column

[Guest]

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

 

[vezerid]

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

=VLOOKUP($A2,'Sheet A'!$A$1:$BP$5000,MATCH(B$1,Sheet A'!$A$1:$BP
$1,0),FALSE)

HTH
Kostis Vezerides

 

[Guest]

Hi,

What you need is an INDEX, MATCH function. For more info check the link below.

http://www.contextures.com/xlFunctions03.html#IndexMatch

HTH
Jean-Guy