Questions tagged [xlookup]
144 questions
0
votes
1 answer
Can you use XLOOKUP to return a relative column reference like VLOOKUP?
if I could use XLOOKUP it would simplify my formulas, but it doesn't seem to offer a way to return a relative column reference like VLOOKUP. For example, with VLOOKUP I had:
=VLOOKUP(I21,INDIRECT($Q$9),4,FALSE)
I21: Text to search…
catdotgif
- 1,738
- 3
- 15
- 13
-1
votes
0 answers
XLOOKUP to find same word in 2 excel cell
I'm looking for a solution for my problem, I've tried many formulas such as VLOOKUP and xlookup but seems like I couldn't get it to work.
The issue here is to find same word from sentences in Column C with Column A and return the value of Column B…
sephiroth
- 43
- 7
-1
votes
0 answers
Is it possible to use XLOOKUP for multiple criteria (boolean method) using table columns as arrays rather than ranges?
I am using XLOOKUP to basically replace INDEX-MATCH array formula combos in my worksheet.
Hoping to make the workflow faster with this. And I have been successful when using the boolean method for multiple criteria, as long as I reference the whole…
Gerardo Alonso
- 1
- 4
-1
votes
1 answer
VBA Excel Lookup on multiple conditions
I have two workbooks where I need to do a lookup in between and obtain a value.
Workbook A with sheet "prices" needs to do a lookup for a specific price in Workbook B sheet "list" on multiple conditions in VBA Excel. I'm not sure how to solve it.…
Tom
- 127
- 1
- 13
-1
votes
1 answer
XLOOKUP - exclude columns based on content
Sheet1
Name
Item_ID
Output
Name1
ID1
some data from Sheet2
Name2
ID2
some data from Sheet2
Name3
ID3
some data from Sheet2
Name4
ID4
some data from…
asaysno
- 35
- 6
-1
votes
2 answers
Add Xlookup to a range via Excel VBA
I tried searching for a solution to my XLookup via VBA problem but I couldn't find one. I have this below data set:
In the Data Set, If any cell in the range C2:C6 is blank, I want to use this formula…
ram singh
- 41
- 8
-2
votes
1 answer
XLOOKUP in Google Sheets works only on the first line with the searched value
I've got a problem with populating whole table in Google sheets. I want to pull out all the data rows based on one product name from A2 cell.
I've created such formula, which taking the data from another sheet and give us searched details.
From such…
Firhed
- 1
- 2
-2
votes
1 answer
Excel Power Query - Save changes made to output table before refresh
I have a workbook with 2 sheets containing the same list of clients, but with different data relating to the client. Both sheets use LastName and FirstName as the first two column headers. Both sheets have about 10 additional columns, each being…
Archie Weber
- 9
- 3
-2
votes
1 answer
How do I return a true or false based on multiple criteria in Google sheets?
In my Google sheets workbook I have one tab (call it Classlist) that has rows with the student's last name, first name, email address, and a series of checkboxes for the quizzes in the course. The columns are the names of the quizzes. In another…
Michael Downer
- 1
- 2