Hi,
I have file with 3 tabs, I want to update sheet 1 which is tab#3 as per criteria, currently I'm using formula but it update half addresses correctly other addresses update wrong, anyone help me to check my formula what is the issue?
attached Excel File
Thanks in advance
In A3 you forgot the $ sign @ beginning of the matrix
so change K3 to K$3 and also for the end of the matrix
and copy down
cheers
Leo
Hi LeoTaxi, it's not working, can you pls help on this issue?
any expert here for help me on this issue?
Leo taxi is correct. just vchange the formula to:
=IFERROR(INDEX(Details!$K:$K,SMALL(IF(Details!$E$2:$E$2866=Planner!$I$4,ROW(Details!$E$2:$E$2866)),ROWS(Sheet1!$A$2:A2))),"")
and array enter it. Copy down
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Glenn Kennedy Thank You
You're welcome and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks