xlookup

Dear Excel Experts, I have a below formula whereby it returns the name with the closest date from today's date. =LET(f,FILTER(I2:I18,E2:E18=R2),XLOOKUP(TODAY(),P2:P18,f,XLOOKUP(TODAY(),P2:P18,f,,-1),1)) While the formula works fine when the range is set with specific rows, when I set the...

Hi, I have the below table and what I need is below: When I choose any team from the dropdown list, I will get the top 3 highest and lowest score for the selected team, then sort the results from lowest to highest for lowest score and highest to lowest for the highest score. I put the desired...

I have an 'xlookup' formula in cell C4 that spills as expected to the required rows, but I'm having an issue with the [if not found] argument not returning the correct data. The data I want [if not found] to return is text in the same row from another spilled array starting in cell E4. (note...

Why does Excel put in xfln in front of my lookup formula occasionally and return #NAME? =_xlfn.XLOOKUP(TRUE,B1:B3000<>"",B1:B3000,,,-1) Doesn't always do it. Version 16.84 (24041420) for Mac Many thanks

Hi, I use Xlookup to get the dates for my details tab. However, I need to refine the formula to get only today and any future dates, without getting old dates or even the dates that is formatted as 1/0/1900. Below is my sample data along with the formula that I'm using. Is there any suggestion...

I am trying to evenly assign work amongst employees based on their availability and language. Please help, thank you very much in advance.

I am trying to add classifications to my leagues based on year. Some leagues change classifications on a year-to-year basis. I am trying to use XLOOKUP to look up the year and the league, and select the proper classification from a range. The problem arises when a league changes...

Hi All, My husband struggles with Excel and finds G Sheets easier to work with. So this is my current situation. I am trying to create an inventory system of sorts. Overall I will not have more than 21 items but to create the final product I might need 3 items up to say 10 items. So what I was...

Hey everyone, I have struggling with this for days now...and my team is depending on me to figure this out soon. I need help with doing some sort of lookup on data that is in different columns below a merged header cell. I need a specific cell to be chosen based on the name that I input. For...

Hi, See attached a sample job scheduling dataset. I need to lookup the bay # and return the job # which is simple enough with an xlookup. However, there will be multiple jobs with the same bay # and I need a way to be able to only pull the job number that starts after a certain date. I would...

Hi, I've been playing around with various alternative XLOOKUP formulas and INDEX/MATCH to lookup values in a table and return a match - where I want matches that starts with "HTJ" to be prioritised. In other words, if a value is found and starts with "HTJ xxxxx" then use that, if not found...

Hello guys i have a data base where i want to first find the column header, 2nd in same column find a certain date, and 3rd return correponding date from same row 1st column. So i have prepared one sample excel file Sheet one - Calc - where user can enter the class and dates Sheet two - Log...

Hi All, Really struggling to get around the below problem. Any help would be appreciated. I have 2 worksheets within my workbook and trying to create a XLOOKUP. See scenario below. =XLOOKUP(WORKSHEET2(A2), WORKSHEET1(116 COLUMNS), WORKSHEET1(COLUMN A)) Worksheet 2 (A2) = My LOOKUP value...

Is there a way to look up a name OR number in a data validation list but only let the user select the number and then have the associated number populate in the adjacent cell? My goal is for users in a file to be able to see the project numbers and/or names (some users search by names and some...

Hi, I have a unique use case so please let me explain. I'm building an xlsx sheet that is used to upload products to eBay via their bulk upload CSV tool. I have various data validation rules, VLOOKUP and CONCAT formulas set up that are making some of the sheet work. The area I need help with...

Hello, I have a file that has IDs and Dates and I need to map this file to multiple excel sheet files that are more than 20 files with protected password. Any suggestions to get this done in easier way rather than open each file and copy and paste into a master file? Thanks, Zina

i need to use Vlookup/Xlookup to pull data from one spreadsheet to another using the address to match address it is this format "7 example close, Example, BB4 9BB"

Hi there. Could someone kindly assist me with an XLOOKUP formula I'm using to pull in data from a master tab to another sheet? I want to pull in data onto "Store 1" sheet based on: Store Number month year line item name (revenue, COGS, etc.) =+XLOOKUP(1,('Data Master'!$B$7:$FZ$7='Store...

I have an invoice reconciliation workbook where the first sheet (Data) is a list of the Planned Amounts by Vendor and Project ID. All of the other sheets in the workbook are broken out and named by the Project ID. I'm trying to compare the Planned Amounts by Vendor on the Data sheet to the Total...

=XLOOKUP(E2:E11,A2:A5,C2:C5,,-1) =FILTER(A2:A5,D2:D5>F2) I want A5 to be dynamic to the last cell with a value. I've tried my hand at sequence and index, but it doesn't seem to work.