Hello,

As you will see in the attached file, I need to extract the details "variance" and "score" of "RESULT X" from Sheet 2 and place them in the correspondent fields in Sheet 1, horizontally.

So far, I've only managed to use VLOOKUP to extract "variance" and "score" from Sheet 2 - B5 and C5, but how about extracting B6 and C6(and so on) of the same "RESULT X" and put them in line like in Sheet 1?

Any help please?

Many thanks in advance!

Attached Files

1.xlsx (9.2 KB, 13 views)