Help!

[mrjeep]

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]

=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.

--

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,