IF Statement with AND

[Qbart]

Hello,

I am not very good when it comes to Excel and I'm hoping this will be an easy question for someone who knows Excel.

I've attached an example Excel file.

This is what I would like to accomplish. In Sheet 2 starting in Cell A2 have a formula or function that will do this:

If in Sheet 1 "Team = Birds" and "Date Completed = blank" then display "Job Number"

Thanks for any and all help!

Q

[Ace_XL]

In row 2

=IF(AND(F2="Birds",G2=""),E2,"")

Copy down

[Qbart]

Thank you Ace, that works when I paste it in cell H2 on the same worksheet but is there a way to have the same thing work from cell A2 in Sheet 2?

[vijay_prabu_cwa]

Hi,

Hope it works =IF(AND(F2>0,G2>0)," ",E2)

[Qbart]

vijay_prabu_cwa thank you that works in the same sheet as well but not in sheet 2.

[Qbart]

Also I've noticed that if I change "Team" to something other than Birds it doesn't change what is being returned.

[Ace_XL]

In Sheet 2

=IF(AND(Sheet1!F2="Birds",Sheet1!G2=""),Sheet1!E2,"")

[judgeh59]

it doesn't show which version of Excel your are using but here is another version

Please Login or Register  to view this content.

[Qbart]

THANK YOU ACE! That works!

[Qbart]

Thanks judgeh59, I'm using Excel 2010

[judgeh59]

nice...then the ISBLANK() could be used here and other places....you can also add that to your online info folks which syntax you have available....glad ACE could help....

EDIT: I left off a few words....OOPS......good job at figuring that out....

[Qbart]

Ahhh I will change that now, thanks judgeh59.