Help!

M

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,
 
B

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.

--
 
Top