All Questions
201
questions
0
votes
1
answer
170
views
VLOOKUP if Client ID is customer during the same month during different years
I have a list containing four columns: Client ID, Year, Month, Recurring customer.
Each transaction during a month creates a row. I want to see if the same Client ID has a transaction on the same ...
0
votes
1
answer
221
views
Inputting several values, found from a VLOOKUP function, into a COUNTIF function
This question is about a single function (in a single cell to later extrapolate over a whole table) in Microsoft Excel.
I want to find a unique id on another page (amongst other id's in the first ...
1
vote
1
answer
65
views
Excel - lookup by multiple criteria
Based on the attached screenshot, I have a sample database on the right side.
I would like to input random models, capacity, and grade on the right side, and receive an output of pricing.
How would I ...
0
votes
0
answers
27
views
Can I make Excel add cells together if they fall between dates and match another criteria?
I'm trying to count the number of widgets sold across a number of different shops on a street, within a certain time frame.
If I could get a VLOOKUP to work, it would look something like this:
=...
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 ...
0
votes
1
answer
252
views
Need to Vlookup a specific phrase in a cell, and then go find another value in another table
Thanks for the assistance in advance!
I've got a table filled with campaign data. I need to write a function to look at a column "IO number" in Sheet 2, Column A, in this example "AM262" and then go ...
0
votes
2
answers
445
views
SumProduct Multiple columns using name for column index Vlookup across multiple sheets
I am trying to sum multiple columns from a table on a separate sheet using vlookup and matching the column index number with a name instead of the column number. I can return a single result but can ...
1
vote
0
answers
200
views
Using Excel, how can I automate incoming weekly reports/audits to pull data and insert into a new report?
I'm trying to figure out where to start with this so I appreciate any suggestions on something I can do some further research on.
My work relies heavily on reports & audits weekly (sometimes ...
1
vote
1
answer
2k
views
Subtract a Vlookup value from another cells value only if a cell has a value
I am attempting to automate a spreadsheet and subtract a vlookup value from another cells value only if that cell has a value. Both values are times (hh:mm:ss) where Q3 will always be larger than the ...
1
vote
2
answers
402
views
VLOOKUP formula with dynamic address (second parameter), depending on current cell
I need a VLOOKUP that doesn't search the entire range of the column, but from an address that changes depending on the current cell.
company1 user1 01/2020
fixed val2 1200,00
fixed ...
-1
votes
1
answer
58
views
What Excel formula to use?
I ONLY have 2 column which is the "date" and "number". I really don't know how to explain it but for example in the date column, i have "12/20/2019" with corresponding number of "123". I want to ...
0
votes
2
answers
95
views
Excel Input letters to value
I want to assign fixed values to input letters. I'm able to do that with VLOOKUP, but the case is that I need this for 100s of records.
For example, I have given values to:
S=50
U=60
P=70
E=140
R=24
...
1
vote
1
answer
350
views
EXCEL - How to use VLOOKUP to get the entire table contents?
I have an Excel sheet with columns:
Screenshot
Data
Table 1 Table 2
METADATA Date ...
3
votes
2
answers
87
views
I want to count IF both condition are true Logically count by AND excel
I have two Columns both are categorical columns. Like Age_group and Engagement_category.
And I want to get count no. of each engagement_category in each Age_group.
| Engagement_category | Age_group |
...
2
votes
1
answer
687
views
False Positive Matching Excel
Hi there I am having trouble with matching because it is showing me false positive match because everytime i enter for example another 14.33 it keeps saying match. What i need help with is find the ...