Questions tagged [xlookup]
The xlookup tag has no usage guidance.
xlookup
187
questions
2
votes
0
answers
33
views
How to sum values until a certain text value is reached
Below is a sample of my data
This is data from a pipe model I created. I am trying to create an excel formula that returns the lengths between bend points (i.e. summing all lengths of "run" ...
- 21
0
votes
1
answer
22
views
Index or xlookup needed - looking to return multiple critera xlookup to same row
Thank you in advance for your assistance. Looking to do either a index/match formula or xlookup (open to any other solutions) to create this view in my sheet.
I am wanting excel to look at column N ...
0
votes
0
answers
59
views
xlookup with mutiple criteria
I'm creating a fantasy football spreadsheet and I'm looking to use double xlookup to return data based on two criteria.
I lookup the values in "draft day" column B in "schedules" ...
- 25
0
votes
1
answer
24
views
Using XLOOKUP in a scatterplot series
I am working in a flight manager workbook where a Departure and a Destination airport can be selected. Once the airports have been selected their coordinates are fetched from a different worksheet ...
- 11
1
vote
1
answer
44
views
Excel search for certain text within cell and return vlookup from a range
In Table 1 I have a column of Names in one tab (column H) and would like to bring in the Contact information (column I) based on a list (columns A and B) in a separate tab (Table 2).
Table 1 example:
...
- 97
0
votes
0
answers
10
views
I am using =SUMPRODUCT(--(D12:V12<>E12:W12-1))+1-COUNTIF(D12:W12,"") to count consecutive dates. Need to not count dates more than 12 months old
I am using =SUMPRODUCT(--(D12:V12<>E12:W12-1))+1-COUNTIF(D12:W12,"") to count consecutive dates. Need to not count dates more than 12 months old. I am using =COUNTIF(D12:W12,">&...
0
votes
1
answer
41
views
Comparing 2 Excel tables using XLOOKUP function cell by cell
I'm trying to compare 2 tables cell by cell, and what I want to achieve is getting '#N/A' (using XLOOKUP function) in every cell that differs from the first table.
So, I would like to see "#N/A&...
- 3
0
votes
0
answers
61
views
How to use XLOOKUP based on lookup values seperated by commas
I have three types of measurements I can take in each room (s/r/b), test numbers, and the room number in which they were performed. One whole test needs a s, r, and b measurement to complete. To save ...
- 13
0
votes
0
answers
33
views
Google spreadsheet / FIND vs Xlookup solution / find value in array
can anybody help ?
Example -
sheet / table one in the row will be name and surname, in the column header date dd/mm/yyyy/, for the name, if person is not present --> will be letter H (holiday).
in ...
0
votes
0
answers
85
views
Lookup Previous Cell Value in Excel
I need some help in creating an excel formula where it will lookup the previous code based on the column name. Please my sample data below:
Column A and B is being added on file daily, what I'm trying ...
0
votes
1
answer
116
views
Xlookup in excel doesnt function in Makearray?
There appears to be an error in excel formula when combining Xlookup with Make array formula:
e.g.
This is a simplified example. I have used y values of constant increments to make the formula ...
- 765
-1
votes
1
answer
391
views
Excel: Lookup '1' and return multiple values
This seems rather simple be cannot currently find a solve for this.
I am currently in a spreadsheet, which has a column that is returning a binary value on the basis of random sampling.
I need to ...
- 3
0
votes
2
answers
50
views
Excel - Summing Multiple Material IDs Cost from one Cell
So, I have a Product that is made of multiple materials, labeled with material IDs. I need to pull the multiple material IDs from the cell and find their associated costs from another table, and then ...
- 17
0
votes
1
answer
77
views
How do I compare two sheets in excel and if there is a match copy and paste the description (cell associated to the match)?
Sheet 1:
PO NUM
Comments
51773
51775
51777
Sheet 2:
PO NUM
Comments
51777
xyz
63814
abc
51773
ghi
63814
def
51775
jkl
I am having trouble getting the PO Number to search and match between ...
0
votes
1
answer
35
views
arrayformula disappears when sheet is sorted in Google Sheets
I have created a document template to help me automate breaking down scripts for my job as an Art Director for Film/TV. I've made good progress with automating the colour coding needed and auto-...
