Find value in a range of cells

How can I find a value in a range of cells?

For example:

A1 = "dog"


B C D E D
1 kiwi fruit cat lemon blue
2 logo ant dog red weak
3 word man wet cot mule

if I use vlookup:
=vlookup(A1,B1:D3,3,false)

that would find the value but this is not helpful.

Suppose the value "dog" appeared randomly anywhere in the B1:D3 range. How can I find that value when I dont know what column or row the value may appear on, just the range to be searched in?

To find if dog is anywhere in a table use =COUNTIF(B1:F3,A1)
To extend the formula: =IF(COUNTIF(B1:F3,A1)=0,"",A1) this will return dog if more then one entry of dog is found in the table.

Hope this helps

Ola Sandström