xlookup

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

Sub Macro1() Dim lastrow As Long lastrow = Sheets("Sheet1").UsedRange.SpecialCells(xlCellTypeLastCell).Row Dim MyPath As String MyPath = "F:\VMWare\" Dim LatestFile As String LatestFile = Most_Recently_Modified_ExcelFile_In_This_Folder(MyPath, "xls") Dim sFormula As String...

Hi I'm wondering how to make this work. BTW I'm using my phone to send this question. I do have 2 criteria and 3 lookup array. Any method to make this work.

ABCDEFGHIJKL1JanFebMarAprMayJunJulAugSepOctNovDec264,40036,40036,70035,00013,0008,50010,20023,60090,7007,50017,5008,500345Oct7,500=XLOOKUP(B5,A1:L1,A2:L2)6Feb#VALUE!D5D5=FORMULATEXT(C5)C5C5=XLOOKUP(B5,A1:L1,A2:L2)C6C6=XLOOKUP(B6,Months_RA,INDIRECT(B6))Apr='Example 2'!$D$2C5Aug='Example...

I have created two custom formulas that each return a two dimensional array that result in dynamic arrays that spill to adjacent fields. The following examples are a mockup of my actual formulas as they are large. Dynamic array 1 is on it's own sheet called "Orders" and looks like this: Custom...

Hopefully I’m not overthinking this. Here’s was I have. (I’ll upload a mini-sheet in a few. I have a data table that is 15 or so columns long but has about 2k rows of data. Export sheet (sheet1) Column A is my salesperson Name Column d is cust service rep. Column N is the name of the...

Hi all, I currently have this graph: I don't really care about the light and dark orange columns, but I need them to stay nonetheless. However, the grey chart rises from a value of about 9300 to 10500 doing this period, which is not that noticeable in this chart to be honest. I would like...

Hi Ive tried various concoctions of formulas to get this to work. Im Stuck now and have no idea so its time i reach out to the specialists :) I have two sheets One called Colleagues and another called Live. Colleagues sheet is a list of names and Departments Live Sheet is Department...

Hi any remedy to make my excel faster? This is some sample of my excel formulas =xlookup = b5&c2, NAME&DATE, LEAVE,"") =xlookup = b6&c2, NAME&DATE, LEAVE,"") =xlookup = b7&c2, NAME&DATE, LEAVE,"") =xlookup = b8&c2, NAME&DATE, LEAVE,"") Then drag the formula until =xlookup = b55&c2...