Stack Overflow
Stack Overflow

Questions tagged [xlookup]

144 questions
0
votes
1 answer

EXCEL VBA Vlookup multiple sheets

Please help a newbie, I just cannot work this out. getting confused. I have a workbook with 2 worksheets. Column A in both worksheets is a part number code. Column B in both worksheets is the discount code for the part number in column A. Column C…
Claire Peacock
  • 17
  • 3
0
votes
1 answer

Xlookup with Multiple Criteria using Excel VBA

In Excel, you can have multiple criteria when using the Xlookup feature. A "normal" Xlookup looks something like this: =xlookup("ThingToLookFor", "Search Range", "Return Range") A multiple criteria Xlookup looks something like…
Benjamin Walker
  • 1
  • 2
0
votes
1 answer

Insert formulas with variable VBA

I have the following code and I am getting "identifier under cursor not recognized" on all portions within the For loop. Sub Finalize_Macro() ' ' Finalize all data on the Offer Data worksheet ' Dim DSheet As Worksheet Dim PSheet As Worksheet Dim…
whoisceleste
  • 53
  • 5
0
votes
0 answers

Need to remove automatic @ placed in Excel formula

All of a sudden Excel 365 started to add an @ to my formula which is assigned via VBA. The documentation says it isn't supposed to affect functionality but IT DOES and gives me #VALUE! error. The formula is correct without it when I manually remove…
Debbi Handler
  • 1
0
votes
2 answers

VLOOKUP exact value and closest date

I have different water tanks and 2 employees who measures the water tanks. Sometimes they measure the volume of the tank on the same day and sometimes not. I want to see how much their measurements differed. I understand sometimes the dates are not…
Zoey Malkov
  • 776
  • 6
  • 16
0
votes
1 answer

How do I use XL Data Tables with XLOOKUP for Data Validation

I have a data table based on a query -> tblPrimaryProducts tblPrimaryProducts has many columns, some of which are Category, SubCategory and Item. If I were to use a filter on Category I would of course be able to see the SubCategories and Items in…
The Frog
  • 85
  • 7
0
votes
2 answers

Using xLookUp in VBA to return range of values

I'm attempting to use Xlookup in VBA. I've used it before as a formula in Excel sheets, but I am stuck on getting it to work with returning a range of values in VBA. For example, the below works fine as Xlookup is only returning a single value -…
Luke Glanford
  • 1
  • 1
  • 1
  • 1
0
votes
1 answer

Excel dynamic named range based on drop down result

I have a table like this: Company Department Coke Coke HR Coke Coke Sales Mars Mars HR Mars Mars Sales At the moment, I'm using dynamic named range formulas to generate in cell drop downs. The formulas…
Brad
  • 1,019
  • 1
  • 9
  • 22
0
votes
0 answers

VBA Mismatch errors, writing a formula

I need some help. I need help with the mismatch error I get with setting Plan="LogInfo[PLAN]" and subsequently. Also need help writing a formula I wrote in excel in VBA format. The lookup would be from LogInfo to Design, to display values from the…
Rene Reyes
  • 1
  • 1
0
votes
1 answer

Compare two excel sheets for missing and new data in Sheet 2 from Sheet 1

I have two excel sheets with numerous rows and columns. Sheet 1 is the baseline sheet and Sheet 2 is the new datasheet. I would like to compare both the sheets and see what data is missing in Sheet 2 and what new data has been added in Sheet 2. The…
mojo_jojo_12
  • 11
  • 2
0
votes
1 answer

How to re-order columns of data in excel / Why Xlookup formula does not work for full set of data?

I'm trying to re-arrange the columns in a data using xlookup function. But not sure why the formula not working in second case (when I try to do it for the whole table) I would like to understand why it is not working... Any other solution to…
The King
  • 4,600
  • 3
  • 39
  • 58
0
votes
1 answer

XLOOKUP [if_not_found] parameter

XLOOKUP don't suppose to show [if_not_found] before [match mode] parameter ? I have office 2019, but one thing is very unclear to me.. I had to insall the XLOOKUP dll, because my excel didn't have it.. and I red that it only comes with office 365-…
Eran Meir
  • 923
  • 3
  • 17
  • 32
0
votes
0 answers

XLOOKUP choosing column to seach within

I am fairly new to Excel, using XLOOKUP(what to search, where to search range, results range) My question is related to the "range", I didn't find an answer to it.. I always see people using specific range to search, for example:E4:E8 Isn't it…
Eran Meir
  • 923
  • 3
  • 17
  • 32
0
votes
1 answer

Using XLOOKUP in two different Sheets and having a variable array extent (VBA Coding)

Hello there I am very new to VBA coding and coding in general so I hope you can come up with a quick answer to my problem. I am trying to get a XLookup-Formula into my vba-Code. The code is referencing to another Sheet ("Chart Plan" and is supposed…
5I5U
  • 3
  • 1
0
votes
1 answer

Xlookup range formula

I got an issue with Xlookup formula for the lookup array & return array. As the 1st one I need to manually select the range for lookup and return array, I try to use Xlookup with multiple criteria to match with the keyword instead of only matching…
Eddy Tan
  • 1
1 2 3
…
9
10