Printable View
i now need this code to look at range Question_4 and if this equals "Expection" thenCode:=IF(ISERROR(VLOOKUP(Question_1,Points_Q1,2,FALSE)),"Error",VLOOKUP(Question_1,Points_Q1,2,FALSE))
other wiseCode:=IF(ISERROR(VLOOKUP(Question_1,Points_Q1,3,FALSE)),"Error",VLOOKUP(Question_1,Points_Q1,3,FALSE))
Can anyone help?Code:=IF(ISERROR(VLOOKUP(Question_1,Points_Q1,2,FALSE)),"Error",VLOOKUP(Question_1,Points_Q1,2,FALSE))
if this helps this is the code I am trying to replace but the criteria above
Code:
.FormulaR1C1 = _
"=IF(OR(ISNA(MATCH(RC26,Ltable!R17C6:R22C6,0)),AND(RC21<>1,RC21<>2)),0,VLOOKUP(RC26,Ltable!R17C6:R22C8,IF(RC21=1,2,3),0))"
=IF(NOT(ISNA(vlookup1)),vlookup1,IF(NOT(ISNA(vlookup2)),vlookup2,...
Sorry for late reply xld .. Been really ill. I don't understand your response can uclarify?
I was just giving you the syntax of how to do it, you would need to embed your formulae in the appropriate points.
thanks for the syntaxbutim stillhaving major issues with this what imn trying to acchieve is below
if question_4 is equal to "exception"
[VBA]
then
=IF(ISERROR(VLOOKUP(Question_1,Points_Q1,3,FALSE)),"Error",VLOOKUP(Question _1,Points_Q1,3,FALSE))[/VBA]
other wise
Code:
[VBA]=IF(ISERROR(VLOOKUP(Question_1,Points_Q1,2,FALSE)),"Error",VLOOKUP(Question _1,Points_Q1,2,FALSE))[/VBA]
In VBA, embedded quotes need to be doubled up.
I have managed to createthis worksheet formula but the vlookup doesnt seem to work right:dunnoCode:=IF(Question_4="Exception",VLOOKUP(Question_1,Points_Q1,3),VLOOKUP(Question_1,Points_Q1,2))
this seems to work? can this be improved?Code:=IF(Question_4="Exception",IF(ISERROR(VLOOKUP(Question_1,Points_Q1,3,FALSE)),"error",VLOOKUP(Question_1,Points_Q1,3,FALSE)),IF(ISERROR(VLOOKUP(Question_1,Points_Q1,2,FALSE)),"error",VLOOKUP(Question_1,Points_Q1,2,FALSE)))
:friends:Code:.FormulaR1C1 = "=IF(Question_4=""Exception "",IF(ISERROR(VLOOKUP(Question_1,Points_Q1,3,FALSE)),""Error"",VLOOKUP(Question_1,Points_Q1,3,FALSE)),IF(ISERROR(VLOOKUP(Question_1,Points_Q1,2,FALSE)),""Error"",VLOOKUP(Question_1,Points_Q1,2,FALSE)))"
is this right xld?:thumb