Array Formula needs making multi-find

[Yongle]

Due to a rather woolly first post on this thread ....
my "solution" array formula assumes that there was only one 5229 to be found in the range (C3:I8)

=INDEX(Sheet1!A3:A8,MATCH(1,(Sheet1!C3:C8=5229)*1+(Sheet1!D3:D8=5229)*1+(Sheet1!E3:E8=5229)*1+(Sheet1!F3:F8=5229)*1+(Sheet1!G3:G8=5229)*1+(Sheet1!H3:H8=5229)*1+(Sheet1!I3:I8=5229)*1,0))

Unfortunately that is not what the OP meant and I cannot modify my formula successfully
OP wants
- to find multiple instances of 5229 within range C3:I8 on sheet1
- get the value from column A in same same row
- put the values in column B of sheet4 starting at B2

Hopefully somone can help the OP
thanks

 

[Graysleaf]

A B C D
1 Jim 23 23 24
2 Kay 23 23 23
3 Pat 19 19 19
4 Ken 17 19 17

Id like to enter a number in array of B1:D17 as indicated "23"
When 23 is entered Id like the name "Jim" to be pasted to another sheet in a text box would be ideal so that I could move it around.
If any other 23's are in array B1:D17 then I'd like them to be in same text box.
column's A-D are calendar dates. Id like the "text box" to only be looking at current day of the week.

If you guys can pull this off, You're amazing!

 

[Yongle]

OP has amended requirements
- there was no previous mention of a "text box" or "days of the week"

To avoid confusion I suggest that no further posts are entered on this thread and that all replies are posted in the original thread