All Questions
51
questions
1
vote
1
answer
92
views
Excel - How do I look up multiple cells from a single reference?
I'm looking to somehow look up a certain amount of cells from a single reference and return them in the same order in another workbook.
For example, say I have 5 different SKU codes (these aren't ...
- 11
1
vote
1
answer
98
views
Excel: Use Cell in Formula Based On Criteria
I have the following Excel workbook sheets.
SHEET 1 contains data on criminal sentences handed down for specific individuals:
| Name | DateOfBirth | DateOfSentence | SentenceYears |
|------|---------...
- 113
0
votes
1
answer
44
views
Assitance with Lookup function for matching two sheets of data
Basically I have two sheets (s1 and s2), and the data is formatted something like below, first is S1:
ID Name
1 Prod 1
2 Prod 2
3 Prod 3
4 Prod 4
5 Prod 5
6 Prod 6
...
- 3
1
vote
1
answer
101
views
Values in a column to rows based on multiple criteria
I am trying to turn a the table on the left side to the one on the right.
How can it be achieved? I have tried This, but it did not work.
- 113
0
votes
1
answer
115
views
Row data distributed into multiple rows on a separate sheet
I have a fuel consumption log, with vehicle id's in column 'C' and fuel consumed and distance traveled for different dates as the headers.
example
I have made multiple sheets based on the vehicle id'...
- 11
0
votes
0
answers
262
views
Excel HLOOKUP to reference multiple Cells as "lookup_value"
In this file:
https://drive.google.com/open?id=1rwPyt7RKLCVIMWEuAxdl3H3vYxXtUX8S
Cell A3 on the first sheet "Import Template" has this formula:
=IFERROR(IF(HLOOKUP(A$2,Sheet1!$A:$ZZ,ROW(A2),FALSE)="...
- 113
0
votes
2
answers
3k
views
Map/Copy values from one sheet to another in excel if they match on column header
This post gets me very very close to where I need to be
How can I copy a column from one sheet to another sheet based on title in Excel?
However if I add an =if(isblank(Sheet1!A2),"",... to the ...
- 113
1
vote
1
answer
74
views
Returning the column header when the progressive difference of values in a row becomes <= 0
I have an Excel table with the initial stock for an item and the projected consumption based on the corresponding dates in the header. I would like to retrieve the date when there is going to be a ...
1
vote
0
answers
74
views
MAX Result of multpiple results from INDEX and MATCH
I am working with 3 columns, fname, lname, & date. Where there will be multiple duplicates of fname and lname. I am trying to write an INDEX & MATCH that will display the MAX result or the ...
- 11
2
votes
2
answers
13k
views
Finding the next higher value in a column
I have two columns, A and B. Column B has values which I need to look up in Column A. However, I don't need to find the exact corresponding value, I need the next higher value.
For example:
Column A ...
0
votes
2
answers
673
views
Lookup Function Giving Inconsistent Results in Excel & Google Spreadsheet
I am trying to create a column of looked-up values using the LOOKUP function. The goal is for the formula to look up the "rank" value of each "name" and print it in the "lookup" cell on the same row.
...
- 115
1
vote
1
answer
172
views
Allow a cell containing multiple delimited lookup source values to also contain non-lookup values
Lookup multiple values in a different table given a cell containing multiple delimited values
Please open the link to see the previously answered question.
Given that context, is there a formula ...
- 25
1
vote
1
answer
363
views
Lookup multiple values in a different table given a cell containing multiple delimited values
I have two tables, which look like this:
I would like Excel to use the value in ID company associated in table 2 (green), look for it in table 1 (orange) and return the value from Company name, or ...
- 25
0
votes
1
answer
1k
views
Need formula to calculate tiered commissions, according to percentages
First off, I have looked everywhere, and every solution assumes that I'm working with dollar amounts, but my client works with percentages. That being said, I need to figure out the formula to ...
- 103
1
vote
1
answer
477
views
Excel formula - creating invoices from data list
I have an Excel spreadsheet with two tabs - one tab is a list of sales data (eg. date, amount, customer name, invoice number) and the other tab is where I want to make very very simply invoices (they ...
- 11