All Questions
51
questions
0
votes
1
answer
63
views
Excel 2013 - How to have a Lookup return the first date after a specified date?
So I am looking to create a function that searches for a unique ID code in one column, and returns a corresponding time stamp from another column. However, there are multiple time stamps attached to ...
- 3
0
votes
1
answer
79
views
Excel: For A1, find the highest subsequent cell before a cell of <A1 is found
I have column of fluctuating prices over time in column A, lets say the price of a particular stock for arguments sake.
In column B I want to know how high the price went, from that point, before it ...
- 13
2
votes
2
answers
2k
views
HLOOKUP: gives inaccurate data depending on the formula for lookup value
I ran into this weird problem while trying to work with the HLOOKUP function. I've built a simple case here to demonstrate.
In the column starting in C7, I will enter the hlookup functions (shown in ...
- 23
0
votes
1
answer
118
views
How to sum horizontal cells based on the value of the cell to their right in Excel
I'm trying to summarize monthly "hours worked" data. Each row is formatted as this example. This example is one week for two employees
Louie, 8, solar, 9, service, 8, solar, 8, solar, 7, service
...
- 25
2
votes
2
answers
2k
views
Lookup a number in a collection of ranges in Excel
As in the example below, I have a table containing a collection of ranges.
Each range has an associated description. I want to look up the description for a number that falls within one of the ...
- 49
0
votes
1
answer
90
views
Excel get value between 2 dates
I'm attempting to retrieve a value from a table with set dates
For example, given the table below, if a user entered the date 01/07/2019 it would retrieve D or 4. If a user entered 01/07/2017then it ...
- 153
5
votes
1
answer
9k
views
How to Index-Match upwards from a specified cell until non-blank
I've got data in sort of a directory tree layout (See picture)
Basically I want to use one lookup code as a reference point and have excel look upwards in the respective columns to display the "...
- 53
2
votes
1
answer
69
views
How can I look up the 2 axis values by inputting a number?
I'm a graphic designer and not very familiar with Excel but I'm fairly sure it's the simplest solution to my problem. I have a table (see below) with 2 axis going from A to L. Inside that table are a ...
- 23
1
vote
1
answer
175
views
Excel Lookup for work sheet comparison
I have 3 sheets. The first one contains data for Shop A, the second data for Shop B, and the last sheet contains the results.
Sheet A & B: Item Code, Name, Brand,and Stock
I want to compare the ...
- 11
-1
votes
1
answer
136
views
Excel lookup table based on time
I need to set up a way that I can tell which shift certain things happen in. I have a table that has all the times, but I would like to attach each time to a shift (i.e. if this happens between 14:00 ...
- 1
0
votes
1
answer
47
views
in ms excel, is there a way to look up an array and edit data on the looked up row?
Just for a quick example, I have this table:
A B
1 student grade
2 john 90
3 paul 93
4 peter 87
5 bill 84
6
7
Range or array is A2:B5.
I want ...
- 1
0
votes
3
answers
981
views
Excel multi table lookup, can you find a more elegant solution?
This is partly for fun, and I hope it doesn't get closed on subjectivity grounds because although "which solution is the most elegant" is subjective, "the current solution is convoluted and ugly" is ...
- 774
0
votes
4
answers
3k
views
Getting last cell in row with data and corresponding data in column A in Excel
I have a spreadsheet that in column A lists dates. Column B may or may not have data in each cell.
The question I have is when I grab the last cell with data in column B, how can I also grab the ...
- 1
0
votes
1
answer
91
views
Looking up the row number of a shared identifier in Excel, and counting the number of cells in that row that meet specific criteria?
I have a sheet that contains a lookup value in columns. I want Excel to look for each value in another sheet, and count the number of instances of a certain word in the row in which it found that ...
- 1
2
votes
2
answers
484
views
How can I get information from one cell in a row, based on the clue of 2 other cells in the same row?
I'm trying to get Excel to give me information in Column C based on the values in Columns A and B.
Cell A and Cell B will contain duplicates, and what I'm trying to do is build a formula which finds ...
- 21