All Questions
16
questions with no upvoted or accepted answers
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
1
vote
0
answers
122
views
Excel: Icon conditional formatting based on column name lookup
I am trying to create a conditional formatting rule for a table which looks up a pass mark in another table and then compares the value to that pass mark. It is meant to be as general as possible ...
- 157
1
vote
1
answer
161
views
Need to lookup values in row and give the corresponding month in the column
I need a formula that looks up the number of sales in a month and stage and gives you the highlighted cells in the columns. It has to count the first cell that the sales start in and then if you have ...
- 11
1
vote
1
answer
5k
views
VLOOKUP and HLOOKUP combo
I am struggling with the following (see snapshot) and I can't understand what I'm missing.
If the id matches, I would like to extract the value of that id in when the values in col2 matches the ...
- 111
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
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
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
1
vote
2
answers
127
views
Formula to search highest value related to a near match reference
I have a list of neutral references which change as per the date so
What I am looking for is a formula that will search Product and return the latest date.
e.g.,
A B
...
- 11
0
votes
3
answers
2k
views
excel formula to look at only 10 digits of the cells
I want to look at only the first 10 digits of the cells.
If the cells that are in column C equals to the cells in column G (but in another tab), then I want the result from column H(from same tab of G)...
- 5
0
votes
1
answer
175
views
Excel lookup returning multiple values in a column
Everyone -
I have seen numerous posts on this site similar to this, however with the way the data is laid out, none will work for what we are trying to accomplish.
I have a spreadsheet with columns ...
0
votes
0
answers
696
views
Memory Exception on Excel Fuzzy Lookup Add In
I have two tables of data with 5 columns - Name, Phone Number, Email Address, Post Code and Order Time. Both tables have around 10,000 rows. I need there to be an exact match on Name, Phone Number, ...
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
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
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