Using If with and & or together

[PATANN]

I have created a spreadsheet for the end users to use that allows them to select from a list the deposit type now I need the bank code to automatically be entered based on the deposit type and there are 3 types of deposits. I have the first have correct but I'm not sure how to add next half.

=IF(AND(E3="Credit Card"), (A1="Prince George Health Department"),"1103-Wells Fargo Credit Card") or
=IF(AND(E3="Cash & Check"), (A1="Prince George Health Department"),"5200-BSV") or
=IF(AND(E3="Electronic Wire"), (A1="Prince George Health Department"),"1106-Electronic Funds")

Please help, I say a message suggesting using INDEX & MATCH it wasn't clear enough.

[JohnTopley]

Try

=IF(AND(E3="Credit Card",A1="Prince George Health Department"),"1103-Wells Fargo Credit Card",IF(AND(E3="Cash & Check",A1="Prince George Health Department"),"5200-BSV",IF(AND(E3="Electronic Wire", A1="Prince George Health Department"),"1106-Electronic Funds","")))

[PATANN]

Thanks but the formula didn't return any information, it may be because I didn't provide the destination for the bank code which is b5

[Tony Valko]

If A1 DOES NOT contain Prince George Health Department then the formula will return a blank "".

If A1 DOES contain Prince George Health Department AND E3 DOES NOT contain one those specific criteria then the formula will return a blank "".

[PATANN]

the formula is in b5 and both fields contain Prince George or the deposit type. Will it matter if e3 has a list they will select.

[Tony Valko]

Will it matter if e3 has a list they will select.

No

I suggest you post a small sample file so we can see what's happening.

We don't need the entire file. Just what's in A1, B5 and E3.

[Tony Valko]

Like this...

=IF(A1="Prince George Health Department",IF(E3="Credit Card","1103-Wells Fargo Credit Card",IF(E3="Cash & Check","5200-BSV",IF(E3="Electronic Wire","1106-Electronic Funds",""))),"")

[PATANN]

Thanks but the formula didn't return any information, it may be because I didn't provide the destination for the bank code which is b5.

[JohnTopley]

Formula should be in B5 if that's where you want the result.