Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: IFS Formula Help XLOOKUP() function lookup_array and return_array must be same length. You mentioned only one cell E2 as return_array argument. So, amend it. Try- =IFS(K2="SCHOOL NAME",XLOOKUP(B2,B:B,E:E,""),AL2="SCHOOL CODE",XLOOKUP(B2,B:B,E:E,"")) Another point is, you are looking B2 cell content inside B column, so it will always return result from E2 cell. In that case you can just use- =IFERROR(IFS(K2="SCHOOL NAME",E2,AL2="SCHOOL CODE",E2),"") But what is your actual goal? Attach a sample file or post few sample data and desired outcome. Re: Compare or search one data table in another table in Excel XLOOKUP(), FILTER() with VSTACK()/HSTACK() may help. Attach a sample file with input data and showing your desired output. You may also share sample file via OneDrive, Google-Drive, Dropbox or similar services. Re: Initializing TextBoxes within a UserForm You can message privately here. Re: Initializing TextBoxes within a UserForm How you are executing the codes? I means which event? This works fine to me with UserForm_Activate event. Private Sub UserForm_Activate() Me.TextBox1.Value = "MyValue" End Sub Re: Excel I am facing same issue since last couple of weeks. Techcommunity authority should take care of it. Re: Need help with conditional fomatting formula based in text on cells Try the following formula in custom conditional formula rule. =OR(REGEXTEST(TEXTSPLIT($C1," "),"CORPORATION|LLC|INC|ENTERPRISES")) Re: Fill dates series of Thursdays, Fridays and Saturdays with fill handle You can achieve this by formula if you wish. =LET(x,SEQUENCE(31,,DATE(2025,12,1)),FILTER(x,WEEKDAY(x)>=5)) Re: Formula help Can you please attach a sample file or share via OneDrive, Google-Drive, Dropbox or similar service? Re: How can I display negative values for time in calculation results If you just want to show negative sign before time value then you could try TEXT() function like- =TEXT(A1-TIME(0,15,0),"-hh:mm AM/PM") To make it conditional you can use IF() or IFS() function. Re: merge cells Here are few formulas- =B1&C1&D1&E1&F1&G1&H1 =CONCATENATE(B1,C1,D1,E1,F1,G1,H1) =CONCAT(B1:H1) =BYROW(B.:.H,CONCAT) Re: How to count duplicates ... sort of ... Here is another way you may try- =ROWS(UNIQUE(HSTACK(C.:.C,F.:.F)))-1 Re: Need help with SORTBY function. Glad to know it works! Re: Need help with SORTBY function. You do not need SORTBY() in this case. You can specify multi column for sorting and individual sort order for each column. =SORT(FILTER('Big 4 NOV 21-23'!A3:E221,'Big 4 NOV 21-23'!B3:B221="M"),{3,4,5},{-1,-1,-1}) Re: Practical use of row_delimiter with TEXTSPLIT Here is a use of row_delimiter. Re: Excel help Your question is quite unclear. Can you explain little more and show your input data and desired output manually. We will try to achieve that output by formula. Re: How to highlight duplicated sequential rows Try the following custom conditional formatting rule. =OR(AND(A2=A3,B2=B3),AND(A2=A1,B2=B1)) Re: power query/ dax measure , multiple conditions/ multiple answers Here is a formula approach if table are loaded to sheet. =PIVOTBY(D2:D12,E2:E12,XLOOKUP(D2:D12,A2:A9,B2:B9)*F2:F12,SUM,0,0) Re: Excel interprets dates 12 and lowers as months It will depend on your compute date formatting settings. Change date formats to your computer from control panel and excel will automatically treat entered data as day, month & year based on that settings. Re: How to extract multiple dates from description? Thanks for response. I have figured out it as =LET(x,FILTERXML("<t><s>"&SUBSTITUTE(A2," ","</s><s>")&"</s></t>","//s"),TRANSPOSE(FILTER(x,ISNUMBER(x)))) Re: Worksheet tabs to include date from a cell You will need to use VBA coding to achieve this.
