lookup function
3 TopicsComplex lookup - lookup in lookup
Hi guys, I´m currently working a lot with SharePoint. I´m not a code expert or It specialist and I do everything with try and error. But currently I reach my limit – maybe you can give me a tip and help me. I work in my current Lists a lot with lookups. But with more and more requests that gets very complex. We have different contact persons for different Areas. We have a lookup column for Area A,B,C,D,E The next column is a Contact lookup – Area A contact 1,2,3 – Area B contact 1,2,3,4,5 and so on Is there a way that Area Column lookup affects the Contact Lookup? When in Colum Area is selected Area A – show me only contact options for Area A I hope I wrote it so that you all can understand it. Thank you very much!!!1.6KViews0likes1CommentCross Subsite lookup list
Hi We have an O365 SharePoint Online site collection with multiple sub sites of student data. Each sub site represents results of a set of students in a particular class from a particular year. I'd like to create a lookup list at the parent site level that displays all the results gathered from all the sub sites for each student. We can then filter that list for each student or each year etc. Can anyone recommend a method of doing this? I can't see how to easily query all the sub site lists and bring the data into a parent list. Thanks in advance.3.8KViews0likes5CommentsHow to exclude cells that contains formula from the range of cells in a LOOKUP function
Hello, I am currently preparing a payment milestone template which also records the last/latest date of payment. I used the this formula to do just that, =LOOKUP (2,1/ (J4:LN4<>"",$J$2:$LN$2)). But the problem starts when I added columns to get the SUM for each activity per month. I wanted to know if there is a condition that I can use to exclude cells with a formula on them. In the first activity "G2-1090", I have deleted the SUM formula at the end of each month and the Last Paid Date column shows the last date of payment which is March 4. But since I wanted to get the sum per month I added a formula at the end of each month to calculate the total payment per activity per month. I have attached the template for reference. I hope someone could give me an advice/solution in this problem. Thank you21KViews0likes10Comments