Hi GD

Use If(and(A1="Cat",B1="Dog"),=C1,"") in cell Z1

where both conditions musrt be true otherwise return a blank.

Merry Xmas.


"GD" wrote:

Hey, if I have a table of data and want to report the figure in a given cell
IF one text arrangement appears in one range of cells, AND another text
arrangement appears in another range of cells - how do we do this?

Eg - i'd want a formula covering ranges A, B, C to pull a result from C into
Z when Cat appears in A and Dog appears in B only..?

A B C.......Z - Cat & Dog
Cat Dog 21 21
Cat Pig 54 0