Solved: if & vlookup

[khalid79m]

=IF(ISERROR(VLOOKUP(Question_1,Points_Q1,2,FALSE)),"Error",VLOOKUP(Question_1,Points_Q1,2,FALSE))

i now need this code to look at range Question_4 and if this equals "Expection" then

=IF(ISERROR(VLOOKUP(Question_1,Points_Q1,3,FALSE)),"Error",VLOOKUP(Question_1,Points_Q1,3,FALSE))

other wise

=IF(ISERROR(VLOOKUP(Question_1,Points_Q1,2,FALSE)),"Error",VLOOKUP(Question_1,Points_Q1,2,FALSE))

Can anyone help?

[khalid79m]

if this helps this is the code I am trying to replace but the criteria above

 
                .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))"

[Bob Phillips]

=IF(NOT(ISNA(vlookup1)),vlookup1,IF(NOT(ISNA(vlookup2)),vlookup2,...

[khalid79m]

Sorry for late reply xld .. Been really ill. I don't understand your response can uclarify?

[Bob Phillips]

I was just giving you the syntax of how to do it, you would need to embed your formulae in the appropriate points.

[khalid79m]

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]

[Bob Phillips]

In VBA, embedded quotes need to be doubled up.

[khalid79m]

=IF(Question_4="Exception",VLOOKUP(Question_1,Points_Q1,3),VLOOKUP(Question_1,Points_Q1,2))

I have managed to createthis worksheet formula but the vlookup doesnt seem to work right

[khalid79m]

=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)))

this seems to work? can this be improved?

[khalid79m]

.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?