Hi Guys,
I am trying to lookup data from one table with a set criteria
In the table I have attached I would like to know if it is possible
On Sheet named Sunday in Column B, I would like to know if it is possible to populate the peoples names from Sheet 'Weekly Summary' Column B where they have a 'Y' in in column D
thanks in advance
Are you likely to want to do this for the other days of the week as well, i.e. to have a sheet for Monday, Tuesday Wednesday etc.?
Pete
I would, yes but I am ok to modify the formula for each day I just cant sole the initial formula
Try this array formula
=IFERROR(INDEX('WEEKLY SUMMARY'!B:B,SMALL(IF('WEEKLY SUMMARY'!$D$5:$D$104="Y",ROW('WEEKLY SUMMARY'!$D$5:$D$104)),ROWS(D$2:D2))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Perfect thank you, i figured it would be an array but i'm still learning about them
You're welcome. Don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks