FORMULA HELP

[markster]

Hi everyone,
Just need a bit of help with a formula.

Basically, what I'm trying to write a formula on Sheet 1 that says if Cell A2 = Cell B2 on Sheet 2, AND, Cell m2 = Cell L2 on Sheet 2, apply my look up formula but if it they don't match, don't run the VLOOKUP just return "No". So I started the formula like this

IF(AND(A2=Sheet2!B2,M2=Sheet2!L2,(VLOOKUP etc, etc.), "No"

I just get a formula error - the lookup on it's own work fine it's when I try to add the IF(AND) can anyone help?

 

[Joe4]

You have an opening "(" for your AND function, but are missing the closing ")".

Your formula should be structured like:

=IF(AND(A2=Sheet2!B2,M2=Sheet2!L2),VLOOKUP(...),"No")

 

[markster]

Ok thanks, but I've entered the formula (cell reference are different from the example above but I believe the formula is correct and still there is an error with your formula message.

=IF(AND(A2=Sheet2!A2,Sheet1!B2,Sheet2!B2,Sheet1!),VLOOKUP(Sheet2!A:B,2,0),"No")

The vlookup bit works fine on its own - any ideas?

Thanks,
Mark

 

[markster]

Actually error is SPILL

 

[Joe4]

Your VLOOKUP formula looks to be structured incorrectly.
I think you are missing the first argument, the value you are actually looking up.
Have you used VLOOKUP before? Do you understand how to set them up?

 

[markster]

Sorry I think I'm brain storm, I can see the error in my VLOOKUP formula - yes I use them a lot sorry to bother you

 

[Joe4]

You are welcome.

Note that I changed the solution to the reply that addresses your original question (and not the latest error).