If and using part of string.

I am trying to combine two formulas but with no luck! I want to check if part of a cell string is equal to "march" and if it is then I want to check if another cell string is equal to "booking" if this condition is met then I want do display the contents of another cell.

So for example cell A1 has the string "2nd March 2015" and cell A2 has the string "booking" the condition is met and I therefore want to display the value of A3.

I tried something like this but it did not work:

=IF(AND(ISNUMBER(SEARCH("mar",A1)),A2="booking",A3,""))

Tried every way I can think of but cannot get it to work the way I want it to...

Thank you in advance for any help

Missing ")"

=IF(AND(ISNUMBER(SEARCH("mar",A1)),A2="booking"),A3,"")

Works a treat. I think that I can further customize this formula so that it is better for my needs. I am trying to search the columns so that if march is anywhere in column A and booking in anywhere in column B then the total of column C will be added up. So A1="march" A2="booking" A3=10, A1 and A2 meet the condition and therefore the value is 10. I need to do this for the whole column though from 1-100. I tried to add a VLOOKUP as I think this is the way to go but I am not very good at formulas! Below is another version I tried but it did not give me the correct value?

=IF(AND(COUNTIF(C21:C24,"*march*")>0,COUNTIF(D21:D24,"*booking*")>0),E21:E24,"")


Is there a way to add VLOOK up into these conditions?

Thank you for your help

WOW,
Thank you so much. My formulas were just getting longer and longer and still not working! VLOOKUP, if this if that....lol

I will keep this formula in my best formulas as it's a great one to keep.

Much appreciated