xlookup

Can xlookup perform a cascade search in the event multiple rows show the same data? I have some data I'm collating and analyzing to see which value is the largest and showing it at the top of the list. However, when there are two values that are the same, it only pulls the first instance...

Hello, I'm looking for a way to truncate the length of data that I'm pulling from another Sheet using XLOOKUP. ABCD1QuizTitleDataLEN2176888A Funny Thing Happened on the Way to School...xxxxxxxxx463178125A Pirate's Mother Goose (And Other Rhymes)xxxxxxxxx424187860Alexander Hamilton: From Orphan...

Hi, I have a below table that EEIDs and some of those EEID have multiple categories, what I need to do is to get only the EEID with Promotion category. The formula I have brings the first category of each EEID only, how can I edit the formula to let it bring only the Promotion category and if...

Hi, I am trying to sum up the amounts belonging to certain categories through their ID number but cannot think of any way to find all matching items - xlookup only finds the first item and I can't have a spilling function like filter. The ID number/amount table and ID No./category table must...

Basically I have a table im adding numbers to and underneath xlookup searches up that value and returns a value and "if_not_found" is set to "not found", however it seems to trigger when a cell is empty? but it doesnt trigger in other cells... but it fixes it if i edit the cell? link to video...

I am creating a UserForm that is pulling records of my customers from a worksheet to my UserForm using this code: ``` Sub employeelookup() SalesForm.BHSDEMPLOYEETD.Value = Application.XLookup(Val(SalesForm.BHSDMAINNUMBERLF.Value), Worksheets("TELEDATA").Range("E:E")...

I constructed an XLOOKUP to find the right rate of a worker from a set of contracts. The rate needs to be added to a list of timesheet records that hold the name of the worker, the contract he worked for, etc. So when every timesheet-row has the right rate, I can construct a pivot that shows the...

I have the following data in excel. I would like to derive the "Action" column for a "Person ID" based on the Y or N indicators in the "Value" column and what's in the "Month" column ABCD1Person IDValueMonthAction21N1/1/231st action32Y1/1/2341N2/1/232nd action52N2/1/231st...

Hello all, I have a wide range of employees data, I have been using normal Xlookup to get the Person Number by looking up the Employee name. However I came across case similar to the example below, there is a two idfferent employees with two different Person Number, but have the same exact...

Hello, I'm trying to figure out a way to get a cells "last modified date" in order to use it with XLOOKUP. I've seen examples where people are using formulas to CREATE a TIMESTAMP in a separate column, but I can't use those examples as written considering I have actual dates in the column that...

Hi I am trying to return a date using XLOOKUP which it does, however, the original date is shown as Date and Time 01/02/2023 12:40:58 and I want to remove the time without changing the format of the cell as when I then use a pivot on the returned date it will still show as date and time...

Heya I don't know much of anything about VBA or coding or whatnot so please forgive any ignorance I may have but if someone could create a macro for me that would be amazing! So I have an excel spreadsheet where I keep track of various entertainment I enjoy and in particular shows and any...

Hi New here and looking for help, I have 2 columns, 1 with Time and 1 with Pressure. I am using a Combo Box to select the Start Time. I then use a Mod formula to get the Time in correct format. I then want to use Xlookup to get the pressure reading at the Time selected but get #N/A error. I...

Hi all, I'm trying to write a formula in order to look for 2 items in a Pivot Table. My table has 2 column: 1- Country (i.e UK, Spain, France etc.) 2- Company name For every new week I have a new Pivot Table and what I'm trying to do is search if Company X (CocaCola for...

Hoping an excel wizard can help me with an issue.. I'm pulling data from a form sheet into a dashboard using XLOOKUP. I want to pull all of the accompanying data for the criteria "Industry" from the form sheet into the dashboard. The issue is I have a ton of duplicates since each "Industry"...

I'm trying to use an XLOOKUP function in Excel referencing a file that is in SharePoint online (aka SharePoint for web) =XLOOKUP(NUMBERVALUE(B9),'https://SERVERNAME.sharepoint.com/sites/XXXStoreDevelopment/Doc...

Hello, I'm having some issues with Conditional Formatting a column in one sheet based on a column in another sheet. The Conditional Formatting only works if both Sheets have all of the same lookup values. If the value doesn't exist in Sheet 2 for example, the value in Sheet 1 will return TRUE...

Has anyone tried more detail about speed test for value lookup formulas? I tried myself but I doubt my experiment. Please see my screenshot. The lookup formulas to compare: (1) INDEX-MATCH, (2) INDEX-XMATCH, (3) XLOOKUP. Formula setting to compare: (1) whole column vs fixed range reference...

Hi, I did use match, index and lookup but now use the xlookup to collate relevant data from different tables for information when adding new data to the new new table. Ie copy contact information to help identify the client to add more data against that client. I have generated an equation...

I am trying to fill the blank within a table with found data from a second table using VBA. It works, but after the first column is found and filled with data the next columns take much longer (about a minute each) to fill. If there is a better method please let me know, I have tried...