View Single Post
 
Old 06-19-2015, 10:24 AM
beginner beginner is offline Windows 7 32bit Office 2013
Advanced Beginner
 
Join Date: Sep 2011
Location: Europe
Posts: 45
beginner will become famous soon enough
Default

Or try

In to cell B3
Code:
=IFERROR(VLOOKUP($A3;Sheet2!$A$2:$F$8544;MATCH(B$1;Sheet2!$A$1:$F$1;0);0);"")
In to cell C3
Code:
=IFERROR(VLOOKUP($A3;Sheet2!$C$2:$F$8544;MATCH(C$1;Sheet2!$C$1:$F$1;0);0);"")
In to cell D3
Code:
=IFERROR(VLOOKUP($A3;Sheet2!$E$2:$F$8544;MATCH(D$1;Sheet2!$E$1:$F$1;0);0);"")
etc
Reply With Quote