xmatch

Has anyone tried more detail about speed test for value lookup formulas? I tried myself but I doubt my experiment. Please see my screenshot. The lookup formulas to compare: (1) INDEX-MATCH, (2) INDEX-XMATCH, (3) XLOOKUP. Formula setting to compare: (1) whole column vs fixed range reference...

Hello, May I ask for some help resolving this query please? I seem to be making an error when I am trying to exclude one field if there is data entered. I will explain further below. I am looking at some data with a series of dates. The dates are used to determine if the submission should...

Hi, I have been working on this statement. Each of these line works individually. When I add them together the first three work, and only in this order. When the fourth is added I don't get the desired result. Is there anything obviously wrong? Is there a better way to achieve the same effect...

I've got multiple payment dates and I want to match them to a time series and populate the cell with the individual payment amounts. Sounds simple use of xmatch and indexing or similar but I'm having a mental block. Any help appreciated

Hello, I really need some help breaking down this formula please :) I currently have a document that I am working on where I have created a field that allows you to search for the relevant information below by entering in the postcode and the suburb. The screenshot below is a sample of the...

I am hoping some of the excel experts on this site can help me with an xmatch challenge i am having. I am trying to see if there is a way to use an xmatch to return the 2nd or 3rd instance of a list of dates without using a helper column. I want to be able to look up a date and the instance...