Excel 2007 : Where all conditions are true then return the contents of the adjecent cell

Hello all, I am having an issue I need assistance please.

I am looking for a formul set that I can enter a range that looks for a list of ID #'s in the cells contained in that range.

The formula will result only where all of the ID's listed are present to match a name column adjecent to it.

So essentially where ID # 1, 2, and 3 are all present and have the same exact name listed in the adjecent column

if ID 2 and 3 show "Mary" but 1 does not, it will not produce a result, but

if ID 1 and 2 and 3 show "Albert" and "George" as they do in the attached spreadsheet example, then it will produce Albert, George as the result.

One sheet carries the data set and the other carries the formula and result.

Thanks For the assistance.

Replace =3 with the number of TRUE you expect
=IF(COUNTIF(O17:Q17,TRUE)=3,N17,"")

O17:Q17 is the range of cells in that given row you are checking.
N17 is the cell with the name of your person.

dip11,
Thanks for the response. I tried the formula in various combination but sorry to say it wouldn't work.
Could you formulize it using the sample spreadsheet, so the columns and rows are the same to produce "Albert, George" as the result.
Maybe I am missing something but tried several variations and no luck.

Thanks

Hi,
No the names are constantly changing, they will actually be merchant names, and constanly changing.
They numbers will be the only constant in any search.