IF AND statement or Vlookup or a Macro not sure which to use.

Try this formula (you may have to adjust the cell references a bit):

=IF(AND(B6=Florals!B2,E6=Florals!C4),Florals!E3,"")

It will return the total number in Sheet 1 if they match, and leave it blank if they don't.

It works, THANKS!
but
I need it to work on all of them. I think just needs a lot of nested. I'm gonna try to figure out the nested to get it from here if not ill post help.

What helps me to visualize nested functions is to think of it as a road with many forks. The IF function goes like this:

IF *this* is true, then do *that* (go down the left fork), and if it is false, do *something else* (go down the right fork).

Putting the following function in cell B1 : IF(A1=7,"HELLO!","GOODBYE!") If A1 = 7, then we go down the left fork which leads us to the text HELLO! or if A1 <> (doesn't equal) 7, then we go down the right fork to the text GOODBYE!

IF(A1=7,"HELLO!",IF(AND(C2>5,A1<4),"SUPER!","GOODBYE!"))

Here, if A1 = 7 we take the left fork to "HELLO!" and if A <> 7, we take the right fork, which now leads us to another set of forks. At this fork, if C2>5 and A1<4, we take the left fork to SUPER! and if not, we take the right fork to

PL see attached file with array formula.

Great explanation. I got the whole thing to work! Thank you so much!

How to mark as solved. lol

Thanks for the compliment.
I have changed formula slightly so that if column C is blank it will give blank result.slight improvement.
To mark the thread solved at the top go to "Thread tools".

Please Login or Register  to view this content.