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 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.
Hi,
I'm having trouble retrieving data from an external workbook using Xlookup in VBA. I can get the code to work with a worksheet in the same workbook, but not another workbook. The error message is 1004 Application-defined or object-defined error and its showing on the .formula line.
I'm...
I have searched through many sites looking for what seems to me to be a very simple answer but nothing seems to work.
This is a bogus workbook that somewhat matches a confidential workbook, thus the fictitious amounts.
In column B you see text from a legend that indicates a specific activity.
In...
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.