xlookup

  1. P

    XLOOKUP will not allow to lookup the entire column. For Google Sheets.

    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...
  2. Z

    Xlookup with multiple conditions

    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...
  3. C

    XLOOKUP - [if not found] argument question

    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...
  4. E

    XLOOKUP xfln

    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
  5. Z

    Xlookup to with multiple conditions

    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...
  6. I

    Evenly auto assign based on availability and language

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

    XLOOKUP on Array with Same Entity on Multiple Lines

    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...
  8. N

    am in going in the right direction using XLOOKUP

    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...
  9. S

    Lookup on Merged Cells and Multiple Columns Below

    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...
  10. W

    Filter Function based on a date nested in Xlookup

    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...
  11. A

    XLOOKUP prioritise values that starts with certain text

    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...
  12. skyh3ck

    1st match column header, 2nd lookup a value in same column, 3rd return corresponding value from the very first column ?? need help

    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...
  13. O

    XLOOKUP - Lookup Array Data in Multiple Columns

    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...
  14. L

    A way to search by name or number in a data validation list and only return the name in that cell and the associated number in the adjacent cell?

    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...
  15. A

    Xlookup, Vlookup and/or VBA for finding, matching and inputting data to separate sheet

    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...
  16. Z

    Ideas and suggestions are needed!

    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
  17. R

    Vlookup/Xlookup using a postal address

    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"
  18. k3yn0t3

    XLOOKUP (multiple criteria) not working

    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...
  19. E

    Write formula to compare planned amounts by vendor in one sheet to approved amounts by vendor in another tab based on project ID

    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...
  20. T

    Xlookup/Filter reference last row change

    =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.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top