Stack Overflow
Stack Overflow

Questions tagged [xlookup]

144 questions
0
votes
1 answer

How do I Perform an Xlookup within VBA with a wildcard cell range?

For a VBA application I am trying to look for wildcard matches (before or after variable) in another sheet. Application.XLOOKUP("*" & Mod_SelectColumns.PnPRefRange & "*", Worksheets("Worksheetname").Range("C3:C119"),…
DanielvL
  • 30
  • 5
0
votes
1 answer

Xlookup and search in MS Excel

I've following sample data: Company Tier Domain Abc Elite abc.com, abc.com.uk, abc.co.in Xyz Professional xyz.hk, xyz.com Def Elite def.sa, def.com Lmn Elite lmn.com, lmn.ca fusion Professional fusiongbs.com, fusion.com I want to…
Shreeuday Kasat
  • 3
  • 2
0
votes
1 answer

Why XLOOKUP formula does not work with implicit wild cards?

In the following example the implicit wild cards do work when COUNTIF is involved. =XLOOKUP(1,1/COUNTIF(D2,"asterisk"&A1&"asterisk"),B1) Please explain why it doesn't work int he following manner =XLOOKUP(D1,"asterisk"&A1&"asterisk",B1,,2)
Zam
  • 151
  • 3
0
votes
1 answer

How to return a specific text if a cell contains specififc text using XLOOKUP?

How to return corresponding texts from column E to column B. I know it is possible by the following lookup formula: But since Excel has XLOOKUP right now and it being capable of whatever lookup can do, please explain how the same can be done with…
Zam
  • 151
  • 3
0
votes
1 answer

How to achieve this requirement using XLOOKUP in Excel?

My requirement is quite straightforward. I have "Col A" -> Sheet1 that has the entries which are say our reference point I am matching these entries to ColA in Sheet2 I want the entries in Sheet1 -> ColB to match Sheet2 -> ColB I have three simple…
souser
  • 5,868
  • 5
  • 35
  • 50
0
votes
0 answers

How to change cell properties on worksheet to avoid XLOOKUP function error 1004?

I have designed a VBA dashboard which saves data in a listbox on the form and also in a table on the worksheet. There are a couple XLOOKUP and Index-Match functions which do work separately for their own argument, but as I do other activities on the…
shahin syr
  • 33
  • 5
0
votes
1 answer

Google Sheets VLOOKUP and MAX to sort the end result

I made myself a task a bit more difficult than I had to but I think it is doable. =VLOOKUP( INDIRECT("A" & ROW()) ;Activations!A2:F ; 3; FALSE) This code is working for taking up ID value specified in A+ROW() in current sheet and looking for it in…
Svetoslav
  • 31
  • 2
  • 6
0
votes
0 answers

Xlookup by last entry without overwriting previous entry

i have a scanner register, using an in and out sheet for when the team member scans a scanner out with time stamp, then back in with time stamp. then the overview shows it all together. my issue is when the a scanner gets scanned out then back in on…
MarkP
  • 23
  • 5
0
votes
2 answers

Why is my Application.XLookup in VBA giving "Type Mismatch" Error?

EDIT: Changed my code to use boolean logic instead of concatenating but am still getting the same error. I am trying to use the application.xlookup in vba, and add extra criteria by concatenating the formula inside this code. Sub employeelookup() …
cheese10234
  • 111
  • 8
0
votes
1 answer

How can I reference the value of a textbox in a UserForm in VBA?

I'm running an xlookup function that i have had previously work on just standard cells, but now i am trying to get it to work from my userform. Here is my code: Sub bizlookup() Worksheets("Input").Range("company").Select ActiveCell =…
Ahoycaptain10234
  • 7
  • 7
0
votes
1 answer

Excel Simplify multiple lines of date ranges for matching criteria

I'm trying to use Excel to return the highest & lowest date option so I can return the true effective/expiration dates without multiple lines. Example of…
Jac
  • 1
0
votes
0 answers

Xlookup function Syntax

I am not well versed with Xlookup formula. And I saw this (screenshot) in one of the posts, which will be helpful to me also in looking up a date between date ranges. If the first syntax in Xlookup formula after parenthesis is lookup_value, then…
mon
  • 1
0
votes
1 answer

Xlookup not working in office 365 when trying to search with wildcard

I have data table that looks like this: A B ?RFQMNKOIM0K1 1 JFFN5KKKK6KYSS 2 TUFFHHKK$FOJ6I 3 (2FOA5ZODERTW 4 ?RFQMNKOM0K1 5 ?RFQMGYRTE0K1 6 ?RFQMNQ#34K1 7 ?RFQM98IKM0K1 8 and another one that looks like…
q74hyu_oi
  • 71
  • 4
0
votes
2 answers

VBA Excel Xlookup refer to table column

I have a code for my ComboBox2 which works properly. Now I want to change values in combobox2 and based on that in the textbox6 get a number which is in a column (Total) which is the 6th column of the table (Table1) in another sheet…
shahin syr
  • 33
  • 5
0
votes
2 answers

stuck with Xlookup in vba

hello. I want to execute the Xlookup function from vba without bothering writing the formula in an excel sheet. I think have checked every page google could offer me about the problem but I couldn't find satisfying results. This for exemple return…
Reiler74
  • 13
  • 4
1 2
3
…
9 10