Extract data from one sheet and write to the second sheet.

[zhshqzyc]

Hello, I have a workbook which has two sheets. I want to extract data from sheet1 and write them to sheet2. The rule: if you look at sheet2, the first column is extract from the first column in sheet1. And the first row in sheet2 is also extracted from the first row in sheet1. Most cells in sheet2 are empty. I want the values be filled respectively.

File is attached. Thanks for help.

[NBVC]

Try, in B2:

=LOOKUP(9.999999E+207,CHOOSE({1,2},0,INDEX(Sheet1!$A:$HF,MATCH($A2,Sheet1!$A:$A,0),MATCH(B$1,Sheet1!$A$1:$HF$1,0))))

copied across the matrix.

A 0 is returned when no match found... to hide the 0's format the cells as Custom: 0;-0;;@

[zhshqzyc]

It looks wrong. Any VBA for it?

[NBVC]

What looks wrong... please explain.

[zhshqzyc]

Okay. Maybe my fault. Thanks. hmm

[zhshqzyc]

One thing, I have to point out. Can you consider string case sensitive?
For example,

Please Login or Register  to view this content.

Thay are in different sheets.

[NBVC]

So you want to match case or you don't care what the case is?

[zhshqzyc]

Could you please perform a case sensitive lookup? I am not familar with it. Thanks.

[NBVC]

I think this seems to do it.

In B2,

Please Login or Register  to view this content.

copied down and across