Stack Overflow
Stack Overflow

Questions tagged [xlookup]

144 questions
1
vote
1 answer

Data appears differently when referencing cell vs XLOOKUP

I have a data set imported from PowerBI into an Excel sheet via a PivotTable. I am trying to grab some of this data based on user input by using XLOOKUP function. data: 1| A | B | 2| 112272 | 64'442…
Claude Hasler
  • 396
  • 1
  • 14
1
vote
1 answer

Converting Excel formula to VBA add-in (FILTER)

I have this formula in a cell, it effectively works a bit like xlookup but actually returns all the matches as a CSV string instead of just the first match =TEXTJOIN(",…
CA_Netsmith
  • 13
  • 3
1
vote
1 answer

Why is formula being used on blank cells in a range?

I am looping thru column A of the ResultsTable only. Column A of the ResultsTable contains a list of FirstNames. If the row in column A of the ResultsTable has a value, then a XLOOKUP formula is applied to column B of the ResultsTable that matches…
Jason McCoy
  • 63
  • 7
1
vote
0 answers

XLookup from different Workbook via VBA

I am trying to develop a search template using xlookup via VBA. The input cell will be a string of numbers and the output will be displayed via a recorded macro from xlookup formula and copy pasting the output as values. Once the search button is…
pyl
  • 19
  • 2
1
vote
2 answers

How to use a VLOOKUP or XLOOKUP when a cell has comma seperated values

I'm trying to find the ID for each value in a cell. I tried using a VLOOKUP but it fails when a cell has more than one value. In this scenario, B2 would be updated to 4,1
Taco_Buffet
  • 227
  • 1
  • 2
  • 16
0
votes
1 answer

Input box and Xlookup Function

I am new to VBA and trying to create a macro in VBA based on the following. XLookup to count columns going backwards instead of a Vlookup. Once the formula finds the cell, then I would like to replace it with a number entered into an input box. Here…
Jeannine
  • 9
  • 1
  • 1
0
votes
1 answer

How can an Excel macro check to see if XLOOKUP is available?

I have an Excel spreadsheet that uses the new XLOOKUP function. Despite a written warning on the main page, users keep trying to run the macros in older versions of Excel and they get weird results. Is there a way to have the macro check for…
Oregonian
  • 1
  • 1
0
votes
0 answers

How do I make an edit to only one part of a formula and copy down a formula so that everything but that one part is not changed

I have a list of rows each containing a production line name ("COM" in this example) and an xlookup formula: =(SUMIFS('Go Get'!$H:$H, 'Go Get'!$B:$B, "COM",'Go Get'!$C:$C, "Production", 'Go Get'!$I:$I, "December"))/1000. So for example the next…
user19547
  • 1
0
votes
1 answer

Why can't my Application.XLOOKUP match numeric values?

My Excel VBA functions works on text values but when the lookup value contains numbers only, the XLOOKUP can't find a match. Range(SelectedCell) = Application.XLOOKUP("*" & Range(LookupCell) & "*",…
DanielvL
  • 30
  • 5
0
votes
2 answers

How do I write a VBA function in Excel that allow me to lookup values (with XLOOKUP) on 60+ Worksheets

I have an Excel workbook consisting of 60+ Worksheets. In the main worksheet, I want to use the XLOOKUP to find and return the value of what I'm looking up. The VLOOKUP function will not work in this case because the return value is in the first…
VBAnoobs
  • 1
  • 1
0
votes
0 answers

EXCEL - Error with Filter/Index Match/Xlookup/Vlookup - partial results

ISSUE I think I am missing something super simple but I have tried the methods above to try and return a single result (a provider name) given an associated provider # (which is really a text value in the cells to allow preceding zeros) and am not…
StillLearningThisStuff
  • 9
  • 4
0
votes
0 answers

XLOOKUP vba via Evaluate(str) gives out #WERT

I tried the below code but I only get #WERT! as a result, even though I get the correct result when pasting the (str) in Excel directly.. :( The below code is there to fill blanks. I have a table with blanks that need to be filled following 4…
Elisa R.
  • 21
  • 2
0
votes
1 answer

Fill blanks with Value found with XLOOKUP in vba

I have been trying to write some worthy piece of code but this keeps on failing, so was hoping on your expertise to help me out ;) My table looks a little like the below: And I need to fill in the blank with the following criteria: If a field is…
Elisa R.
  • 21
  • 2
0
votes
1 answer

XLOOKUP function if columns misplaced

I have two sheets, Both Sheet1 & Sheet2 consists of 6 columns which are: Shop Name Shop status Business Type City Operating hours Delivery model The below INDEX MATCH Function finds shop name in Sheet2 and returns exact values of shop status…
Barnet Latoya
  • 33
  • 4
0
votes
0 answers

Xlookup gives N/A even if the date is in lookuparray

My col B has a value for each hour in C. I am trying to match get the value from B for matching value in A. I have tried out with XLOOKUP, but it gives 1 match and two N/A :s repeatedly (picture). Should i use another function or should it work with…
JaniH
  • 41
  • 3
1
2
3
…
9 10