Hello, sorry to bother you guys again!!!
I am trying to extract all the data for each corresponding month from the master sheet in to separate sheets, I have used a look up I don't think is the best way to do as its gives me blank rows. Please help!!
I have attached my working file
Thank you
Suraiya
In O3 Cell of Master Sheet
=IFERROR(VLOOKUP(C3,LookupLists!A:C,3,FALSE),"")
Drag it down…
In D5 Cell of Feb Sheet - Array Formula - Requires CTRL+SHIFT+ENTER
=IFERROR(INDEX(Master!$F$1:$F$50,SMALL(IF(Master!$O$1:$O$50=$B$2,ROW(Master!$O$1:$O$50)-MIN(ROW(Master!$O$1:$O$50))+1),ROW(A1))),"")
Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.
Drag it down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thank you sooooooooooo muchhhhhhhh Sixth Sense!!!
Glad it helps you and thanks for the feedback and rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks