xlookup

i need to use Vlookup/Xlookup to pull data from one spreadsheet to another using the address to match address it is this format "7 example close, Example, BB4 9BB"

Hi there. Could someone kindly assist me with an XLOOKUP formula I'm using to pull in data from a master tab to another sheet? I want to pull in data onto "Store 1" sheet based on: Store Number month year line item name (revenue, COGS, etc.) =+XLOOKUP(1,('Data Master'!$B$7:$FZ$7='Store...

I have an invoice reconciliation workbook where the first sheet (Data) is a list of the Planned Amounts by Vendor and Project ID. All of the other sheets in the workbook are broken out and named by the Project ID. I'm trying to compare the Planned Amounts by Vendor on the Data sheet to the Total...

=XLOOKUP(E2:E11,A2:A5,C2:C5,,-1) =FILTER(A2:A5,D2:D5>F2) I want A5 to be dynamic to the last cell with a value. I've tried my hand at sequence and index, but it doesn't seem to work.

Hi, I'm having trouble retrieving data from an external workbook using Xlookup in VBA. I can get the code to work with a worksheet in the same workbook, but not another workbook. The error message is 1004 Application-defined or object-defined error and its showing on the .formula line. I'm...

I have searched through many sites looking for what seems to me to be a very simple answer but nothing seems to work. This is a bogus workbook that somewhat matches a confidential workbook, thus the fictitious amounts. In column B you see text from a legend that indicates a specific activity. In...

i have a table of 6 column first 3 tables already have data in it in a certain sort i would like to keep second 3 table which i will put data in i want if any data i put in column let say 6 matches with any data with column 3 it will put what i wrote in same row number as its in column 1 let...

Hi. I have a list of unique IDs (column A) with different dates in column B, C and D. If one of the dates are 1 year old, or older, I want the ID and the age (today() - date in column B, C, D) to be presented in a list in Column I (ID) and Column J (age of date), up to a maximum of 10 results. I...

Hi, I have two sheets that I need to map, I used xlookup based on employee ID, but what I need is to use employee ID and payment data: not sure why I get error 91 when I tried to copy as mini table or sheet, but here's the table and formula I used, if anyone can help with adjusting the formula...

Hello Massage board I have got a sheet that shows what delivery quantities I'm expecting. If the cell shows 0 then nothing is required, however, I'm wanting to colour the cell interior a different colour based on what supplier the goods are coming from. The cells i want to colour are in D5:X5...

The last argument in XLOOKUP allows performing a binary search but XLOOKUP only returns one match. IF(value=lookup_array,return_array,"") returns all matches in an array but is slow on large lookup ranges/does not do a binary search. Would anyone know a fomula - or combination of - that both...

Hello, I've been tinkering with XLOOKUP function to bring up multiple values but I've not had much success. I need to lookup codes (fruit in the example below), which can have multiple values (all in the same column, but different cells), which need to be consolidated to a single cell and comma...

Hello! I am trying to find a formula where, using a static book size (say $1550000) and dollars over goal (say 250000) it will return the % at which commission is applied & can then calculate the annual bonus. For the example this would be 4% as the book size is between $1.5m and $2m, and the...

Hi Forum, This is my first time posting. I am usually able to find my answer to other questions by looking through the forums but I haven't been able to find an answer for this issue I'm having. So I am reaching out to the experts on here. Please and Thank you! I need to auto populate dates...

Here is my code, first off: Sub namelookup() SalesForm.BHSDTAPNAMELF.Value = Application.XLookup(Val(SalesForm.BHSDMAINNUMBERLF.Value), Worksheets("NICK TAPS").Range("S:S"), Worksheets("NICK TAPS").Range("T:T"), Application.XLookup(Val(SalesForm.BHSDMAINNUMBERLF.Value), Worksheets("CB...

I was basically working with XLOOKUP functions and I need to be able to pull data from two separate tabs. My goal is to automate this process as much as possible to avoid the need for all those manual adjustments with each XLOOKUP and reference cell change. I have got: In Row 1, I'm using the...

Hey all! First off, here is my code: Private Sub PopoutLeadListBox_DblClick(ByVal Cancel As MSForms.ReturnBoolean) Dim selectedItem As String selectedItem = Me.PopoutLeadListBox.Column(11) SalesForm.BHSDTAPNAMELF.Value = Application.XLookup(Val(selectedItem), Worksheets("MASTER...

I am tasked with finding an easy way to search a list, look for the #N/A returns from an XLookup, and copy and paste values the row containing the error into a new worksheet so all of the errors are in 1 list that can be audited. The list looks like this: ABCDE1Last Name, First...

Can xlookup perform a cascade search in the event multiple rows show the same data? I have some data I'm collating and analyzing to see which value is the largest and showing it at the top of the list. However, when there are two values that are the same, it only pulls the first instance...

Hello, I'm looking for a way to truncate the length of data that I'm pulling from another Sheet using XLOOKUP. ABCD1QuizTitleDataLEN2176888A Funny Thing Happened on the Way to School...xxxxxxxxx463178125A Pirate's Mother Goose (And Other Rhymes)xxxxxxxxx424187860Alexander Hamilton: From Orphan...