Ok, I have 7 sheets named: joe, kelly, meg, nate, dave, tom, sam

To keep it simple, in cell B2 on each sheet there is either "10" or
it's blank.

On an 8th sheet I'm trying to determine a formula to use that will
display the person or persons if their cell B2=10

So if meg's B2 has 10 and tom's B2 has 10, while everybody else B2 is
blank; the formula would produce meg & tom.

What formula would I use? Please help. Much appreciated for your help!

Thanks,


--
mrjeep
------------------------------------------------------------------------
mrjeep's Profile: http://www.excelforum.com/member.php...o&userid=34001
View this thread: http://www.excelforum.com/showthread...hreadid=537639

=IF(Sheet1!B2=10,"Joe = "&Sheet1!B2,"")&IF(Sheet2!B2=10," Kelly =
"&Sheet2!B2,"")&IF(Sheet3!B2=10," Meg =
"&Sheet3!B2,"")&IF(Sheet4!B2=10," Nate =
"&Sheet4!B2,"")&IF(Sheet5!B2=10," Dave =
"&Sheet5!B2,"")&IF(Sheet6!B2=10," Tom =
"&Sheet6!B2,"")&IF(Sheet7!B2=10," Sam = "&Sheet7!B2,"")

You will need to adjust the Sheet names to suit.

--

mrjeep Wrote:
Ok, I have 7 sheets named: joe, kelly, meg, nate, dave, tom, sam

To keep it simple, in cell B2 on each sheet there is either "10" or
it's blank.

On an 8th sheet I'm trying to determine a formula to use that will
display the person or persons if their cell B2=10

So if meg's B2 has 10 and tom's B2 has 10, while everybody else B2 is
blank; the formula would produce meg & tom.

What formula would I use? Please help. Much appreciated for your help!

Thanks,


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=537639