Can comeone help me with below code.
I have this formula - =IF($A4<> "",VLOOKUP($A4,Pivot!A:AZ,MATCH("Grand Total",Pivot!$A$2:$AO$2,0),0),VLOOKUP($B4,Pivot!A:AZ,MATCH("Grand Total",Pivot!$A$2:$AO$2,0),0)) which needs to be entered in sheet1 of my workbook. it has be enetered in the 3rd row of the first empty column where there there wont be any data(except in first two rows).
for example in my case G column is empty except it will have data in G1 & G2. when code looks for an empty column G will be the first one and the formula needs to be entered in G3.
I have this formula - =IF($A4<> "",VLOOKUP($A4,Pivot!A:AZ,MATCH("Grand Total",Pivot!$A$2:$AO$2,0),0),VLOOKUP($B4,Pivot!A:AZ,MATCH("Grand Total",Pivot!$A$2:$AO$2,0),0)) which needs to be entered in sheet1 of my workbook. it has be enetered in the 3rd row of the first empty column where there there wont be any data(except in first two rows).
for example in my case G column is empty except it will have data in G1 & G2. when code looks for an empty column G will be the first one and the formula needs to be entered in G3.