In one worksheet, I am entering a formula that looks in column A of a second worksheet for a match to a certain cell in the 1st worksheet.

worksheet 1 says "michael" in cell a3

worksheet 2 has names in column A Rows 1 thru 10 and "michael" is in row 7.

In the first worsksheet I entered {=if(ws2.xls!a1:a10="michael","yes")}
and I get false as a result.
but if I enter {=if(ws2.xls!a7:a10="michael","yes")} I get "yes" as a result.

Please let me know what I am doing wrong here.

Thanks very much.