xlookup

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

I purchased a Kindle copy of Bill Jelen's Excel 2021 Inside Out. Chapter 9 discusses how, thanks to Dynamic Arrays, a single XLookUp formula can return multiple values. The example used on page 229 is what I want to discuss. At first this seems like a cool idea. But that's because the Inventory...

Hi everyone, I'm aiming for a formula to split out the minimum option based off numerous conditions; although instead of returning the numerical value I want to know the corresponding value in a text based column. I'm thinking a combination of index/match/min/arrayformula/xlookup is required...

Hi, I have below table that has duplicate values for each EEID and what I need is to map those EEID to another table that has business and home for each EEID, when I use the xlookup the formula brings one the first value, as you see in below table and what I need is to get the expected result...

Hi folks, I thought this would be simpler to figure out...but I can't quite get the result I'm after. Mini-sheet attached. Table has Population, Run (First, Second or Third) and a Sample Value. Goal: User selects/enters population letter in G2, this returns in H2 the sample value from the...

Hello excel experts, I want to grab a list of unit numbers based on criteria in another column. If a row in column G contains "Tax Credit", return the corresponding row value in column B. There is a formula that accomplishes this task: =INDEX(Sheet1!$B$8:$B$86,SMALL(IF("Tax...

Hello excel experts, I am using a two-way XLOOKUP() to grab a range of lookup values from a dynamic column lookup. The formula I am currently using is: =SUM(XLOOKUP($C$11:$C$43,INDIRECT("'"&G$10&"'!"&"$A:$A"),XLOOKUP($D11,INDIRECT("'"&G$10&"'!"&"$6:$6"),INDIRECT("'"&G$10&"'!"&"$1:$1048576"))))...

There might be a much easier way of doing this, but I'm struggling to come up with a solution. I have columns month, person and payments. A month can have multiple persons, and not all people need to appear every month. What I want to return is the payment sum per month as well as a sum of...

Hello, I'm a little new to Excel and completely new to this forum. I've run into an issue I cannot wrap my head around since variations work just fine but I feel I'm missing knowledge nobody inhouse can teach me, but I'm trying to understand why my formula isn't working. I'm not native English...

Hi there! I am reaching out to you to see if someone can help me with this excel problem. Essentially I want it to look up two criteria, say, Depart # and Type of Pay (like Gross Pay); I want it to match each one and sum up all the amounts that match in that column to the department giving me a...

Hi all, I currently have a data set that looks like this: I would like to transpose my information down under columns H-L so that for ALL cells in A that contains "George", their respective cells in columns B-F will be transposed under column H. Likewise the same for all cells that contain...

Hi all, I currently have a large data set, it looks like this: I want to vlookup my data from column A-C into column J-L. However, as the names reappear and sometimes even share the same date (example in A4:B5) a vlookup won't be feasible. The dates are correct in my other table, as well as...

Hi all, I have this file that was converted from PDF to Excel. I would really like to filter everything in column A by date However, when I do it looks like this: It filters down until row 687 The row looks like this: I have no idea why it stops? It used to stop at points like these...