S sa.1985 Member Mar 30, 2012 #1 Dear Sir, Please find the link https://rapidshare.com/files/3785902112/Questions.xlsx Need formula help
Dear Sir, Please find the link https://rapidshare.com/files/3785902112/Questions.xlsx Need formula help
Hui Excel Ninja Staff member Mar 30, 2012 #2 In E6 you can simply put: Code: =IF('Entry sheet'!$C$4="x data",'Data x and y'!D7,'Data x and y'!J7) Copy across and down
In E6 you can simply put: Code: =IF('Entry sheet'!$C$4="x data",'Data x and y'!D7,'Data x and y'!J7) Copy across and down
SirJB7 Excel Rōnin Mar 30, 2012 #3 @Hui Hi! For copying in both directions shouldn't it be $C$4 instead of C4? Regards!
S sa.1985 Member Mar 31, 2012 #5 Dear Sir, This is ok but i am getting only one cell answer, I want get answer as E5 : I23 which i mentioned in answer sheet.
Dear Sir, This is ok but i am getting only one cell answer, I want get answer as E5 : I23 which i mentioned in answer sheet.
Hui Excel Ninja Staff member Mar 31, 2012 #6 So put the formula Code: =IF('Entry sheet'!$C$4="x data",'Data x and y'!D6,'Data x and y'!J6) in E5 and copy across and down to suit You will then need to reformat the Top row (5) to suit
So put the formula Code: =IF('Entry sheet'!$C$4="x data",'Data x and y'!D6,'Data x and y'!J6) in E5 and copy across and down to suit You will then need to reformat the Top row (5) to suit
