Looking for a function for multiple conditions

I'm looking for a formula where two conditions are met. i.e. I would like to see the information in cell F1 appear in G1 if D1=San Diego and B1=Y or I would like it left blank if the conditions are not met.

Thank you for your help

Try SUMPRODUCT in cell G1:

=SUMPRODUCT(--(D1="San Diego")*(B1="Y")*(F1))

This will return F1 if both conditions are met or 0 if they are not met. If you want to return blank instead of zero, use:

=IF(SUMPRODUCT(--(D1="San Diego")*(B1="Y")*(F1))=0,"",SUMPRODUCT(--(D1="San Diego")*(B1="Y")*(F1)))