LinkBack URL
About LinkBacks
Hello guys,
can you please assist on what formula I can issue so that the data on sheet2 can be plotted in the summary sheet. Kindly see attached. Thanks in advance for the help.
Hello guys,
can you please assist on what formula I can issue so that the data on sheet2 can be plotted in the summary sheet. Kindly see attached. Thanks in advance for the help.
Like this?
Copy across and down to fill out the dates
=IFERROR(LOOKUP(2,1/((Sheet2!$A$2:$A$1000=$A3)*(Sheet2!$C$2:$C$1000=B$2)),Sheet2!$B$2:$B$1000),"")
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks