xlookup

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

Hi all, I am very rusty in Vlookup (embarassing!) and I am currently looking at this data: I would like to create a formula that checks the same date in column A, as checked in column F and then tells me whether or not the value for this date is also present in my data set in columns F-G. I...

Hi all, I am trying to use an Xlookup to return the max date from column C (sheet2) where there is a matching value in column A (sheet1) against column B (sheet2). This is the formula for my two failed attempts below. =IFERROR(XLOOKUP(MAX(A1),Sheet2!B:B,Sheet2!C:C,""),"") Answer returned =...

Hi everyone So I posted in here a few weeks ago and someone wrote me an excellent VBA which cuts and pastes rows to different sheets depending on what's written in column F of my workbook. The code is as follows: Sub sort_my_data() 'VBA written by SQUIDD from MrExcel.com...

Hi everyone I copied the following code from a YouTube tutorial: The code does as instructed but the workbook is very slow and sometimes crashes. I am using =XLOOKUP formula to retrieve data from another workbook called Mail Merge Data to return a customer's name, address, suburb, and...

I was wondering if there is a functionality in XLookup that can return all valid entries when the look-up is done on more than one criteria. Does Xlookup have the capability to 'spill' like the filter function do? Below is an example: I would like to display all returns for the two parameters...

HI Everyone, I am having some trouble doing a 3 way lookup using Xlook. I have two large tables of Product Inventor and Store sales. The goal is to bring in the sales information to the product inventory. The problem is each product can be ordered by multiple stores. To do this, I have to look...

Good Day - I am working on a workbook that has two sheets FIND_PLC and UGRADADID20220608 On FIND_PLC in Column A I have a list of user ID# (they are text strings in the format of 00000000). In Column S of this sheet, I want to get their EMAIL address which is listed in the Column E of...

Hi all, I currently have this formula: The formula is supposed to look at the values for the company (column B) and the topic (column F) and then based on the value in column F, it will look at the sheet with the same name and find the values here: I likewise have a sheet with the same name...