Quote:
Originally Posted by ExcelVlookup
It would be very nice if someone could help me.
|
If I understand you, try this formula
On Sheet1 in to cell B3 put this formula and copy to right and to down to last row
Code:
=IFERROR(VLOOKUP($A3;Sheet2!$A$2:$F$8544;MATCH(B$1;Sheet2!$A$1:$F$1;0);0);"")