xlookup

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

Hello, I am wanting to spill an xlookup of a maximum number but am hitting a #VALUE error. The basic format is: week cat rat intended result basic intent 2 34 16 cat =xlookup(max(b2:c7),$b$2:$c$7,$b$1:$c$1)) 3 48 24 cat 4 37 15 cat 5 25 40 rat 6 54 45 cat 7 38 39...

Hi all, I currently have a list that looks like this (albeit much much much larger in reality): I would like to create a slicer for column D (Height (CM)). However, my table is not a pivot table. Does anybody know how to do this? I read online that I have to go into the design tab and do it...

Hi all, I have this overview at the moment: If I manually choose to save my file as a PDF, it works fine and I get just 1 page with the overview above. However, I have the following VBA code to save my file as a PDF: Option Explicit Sub SaveFileWithMacro() Dim Path As String Dim fn As...

Hi all, 2 questions: 1) I have the following setup: I add new files quarterly to my excel file, so Q1 2021, Q2 2021, Q3 2021, Q4 2021, Q1 2022, Q2 2022 etc. Right now I only have one for each year, but I plan to add many more going forward for 2022- Does anybody have a way in which I can...

Hi all, I currently have the following setup: I have some numbers in column C and D, and I use a simple sum() formula in column B. However, I also want to be able to click on the cells in column B and see the value in the formula bar. But I want to keep the formulas in the meantime. What I...

Hi all! I currently have this setup, please note that I have hidden all the nonrelevant columns however: The formula I use is this (thank you @RoryA !) =IFERROR(INDEX(INDIRECT("'"&H504&"'!$U$3:$U$73"),MATCH(1...

Hi, I'm struggling to find the way in how to use xlookup function, to obtain data from another workbook, but without using the workbook name/path. I want to avoid using the name of the workbook and the path, because its going to be changing each day both name and location, earlier in the macro...

Hi all, Is there an "or" function per-se for lookup values under XLookup? Below I have a table that has a couple of different name combinations. I would like to be able to lookup both name variations in the table below (Preferred name column AND the reverse name column) and then return the...

By the title, you've guessed I'm struggling to find the right path for what seems pretty basic. But trying to adopt the formulas from the posts and the videos leads me to #REF! despair! The attached Workbook has been reduced to the important parts: A worksheet called "Pine Lakes Front" and...

Hi Am using a Wildcard Search in an Xlookup =Xlookup(”*”&A1&”*”,B5:B199,C5:C199,,2) Works fine if the lookup cell contains a value, when the Lookup cell does not contain a value matches with first cell to contain a space anywhere, cannot work out a way to stop this behaviour, Does anyone...

Hi, I am using xlookup to pull some information from another sheet in the same workbook. The 'return array' is formatted as currency (not sure if this matters), but its not pulling as currency. Its pulling as a general number, but when attempting to format the destination cell to currency it...

Hi, I have a table that has below format and need to update the amount from different table that has a different format, I tried using Xlookup and Index/Match but for some reason it didn't work. Could anyone help me? What I need to accomplish: - The template I have has 3 columns (Employee...