If statement multiple conditions and criteria

[PowerZ]

Hi all,

Forgive me for the code I have put below but I have typed it out on my iPad as I do not have access to my laptop s the syntax and the full code isn't there but on my actual spreadsheet it's correct.

Please Login or Register  to view this content.

So as you can see it's the if statement with multiple criteria that wasn't working ..

It kept just going to the final else statement where the msgbox said criteria not met.

So the if statement checks a cell on a sheet that has the value one and then check the last record of the other sheet, the value in column c and if it is has the value GHS. IF it meets them both it will do the following action.

I can't see what I am missing.

Maybe it's something silly but I'll try post the proper code tomorrow morning (15 hours from now) if it's something more complicated.

Thank you

[JLGWhiz]

the only thing wrong here is

range("b & lastrowMaster")

the second quote mark is in the wrong place. should be right after b. I tested the statement with the quote mark in the correct position and it worked OK.

[PowerZ]

If instr(1, sheets("sheet2").range("a3"), "1") > 0 And instr(1, sheets("sheet1").range("b" & lastrowMaster).offset(0, 2).value, "GHS") > 0

The criteria "GHS" i've noticed that it does not meet the criteria if it is in normal text but if its in CAPS then it matches. How can I make it so if the text GHS in any form is met?

[Greg M]

Hi there,

Try:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[PowerZ]

Hi there,

Try:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Thank you!!!

[Greg M]

Hi again,

You're welcome - glad I was able to help.

Regards,

Greg M