#xlookup

Hello! Wondering if anyone can help... I've been stuck trying to figure out how to exclude blanks with an XLOOKUP. I've tried many different variations of formulas, but nothing seems to achieve what I want. I am trying to have one single consolidated list based on the data with no blanks pulled...

I am really struggling with this and while its just the first part it technically controls everything else. Say I have 18 (I've only shown 12) rows and the data represented in these rows are dependant on a table (for want of a better word) The table contains 4 pieces of information which will...

hello every one as you see the formulas cell is the red one and there are two sheets the left one is total so i try to get the amount from total (sheet) to the right sheet but there are duplicate values in lookup array (F) column what is solution to consider the duplicate values to get the...

Dear All, I have a small apparel business setup from home. I want to automate the workbook so as to cut the time of recounting the products and calculations. I have two sheets the first contains my stocks and second Clients orders. I want to automate in Allocation Column where I want a...

Hello, I'd like to do a multiple criteria lookup to find the cost per unit of a book. I'd normally use Index and match to do this but I'm having trouble because one of my lookups is not exact and is in a range. I tried doing boolean logic with an xlookup, but I can't get it to work unless...

Hi, Any idea how to return "Not Found" instead of N/A when value is not found XLOOKUP? Kind regards, Julie Bunavicz

So I have two worksheets in sheet 1 I am trying to perform a vlookup function that goes as follows XLOOKUP(B55,'Sheet2'!P:P,'Sheet2'!D:D) where the lookup value is 16/02/2023 00:00. I know this value is present in column P of sheet2 and that it has a corresponding value in column d but whenever...

Hi, Please help me i'm only a beginner in VbA. I got a lot of names in cell B more than 60 names and 31 rows for date. BTW this is for a leave tracker. My code is For x = 5 to 55 Cells(x, 3) = application.evaluate("=xlookup(B&C2,NAME&DATE,LEAVE,"" "")") Cells(x, 4) =...

I currently am working with data that is not very consistent in formatting. There are a lot of small exceptions that I work with in my data that make columns and rows not consistent in formatting (ex: column G in one spreadsheet could line up with column K in another). I was wondering if there...

Hello hope this is easy answer that I’m missing I’m wanting to use a RIGHT function on a return value The return value comes from an Xlookup that needs to be active (can’t’ copy and paste values then use RIGHT) The value that XLOOKUP returns is 360abc I want the 360 gone automatically each...

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

I have no idea what’s wrong with X look up Here’s what Im trying to do: Im trying to make excel compare columns then minus the value leaving me with a total so i know how much to transfer/ swap out for each location in 1. Column A-D shows the out of stocks/ lows for CA 2. Column E-H...

I need to create a spreadsheet of reviews for a project I'm working on. I have a library of reviews sorted into 4 columns of product code, star rating, name and review. I have a separate workbook where on sheet 2 I paste the product codes that I need review codes for then it searches the library...

Dears, As per discussion on Youtube Channel, please find hereinafter the spreadsheet to help in find out a method to handle the DATA redistribution over other sheets. How to distribute DATA in Sheets (INPUT1 + INPUT2) based on Columns J " CODER" over the the other sub sheets {LELA, AMAL, BURAQ...

Hello, I am currently working on way to track my swimmers times over the course of a season and track what place they maintain on my team. The current problem that I am running into is that if two swimmers go the same time the two times separately show up in the ranks... but there is only one...