Help me to create a formula with 3 condition, So that I can pull data from another sheet

Ganeshaa

The formula should include these 3 below condition.

1. Job status is complete
2. Brand name is Ganesh Fathima
3. Total savings

The result of these formula should satisfy all these above condition.

Many thanks in Advance!!

MCorbin

I think we need a little more information.

Are you trying to Sum or add data from the other sheet for rows that that match these 3 conditions?

Or are you trying to do a data lookup from a sheet where the row in the other sheet has columns with these same three values?

Ganeshaa

Thank you for the response, I am trying data lookup from a sheet where the row in the other sheet has columns with these same three values.