All Questions
Tagged with worksheet-function vlookup
216
questions
0
votes
3
answers
3k
views
EXCEL: Number of days since last visit
I am trying to calculate the number of days since a specific person last visited a location.
Looking at the following sample dataset, what would be the best method?
I tried making an index column and ...
0
votes
3
answers
281
views
Excel formula help multiple criteria drop down
Hi,
I am hoping for some help in a V look up when using two drop downs for todays date (G1 & G2).
The table on the right are calls made each day will contain data of calls made by employees, it ...
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
220
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 ...
0
votes
3
answers
339
views
Vlookup is not working fails with N/A return despite i have value
My Vlookup function isn't working, it fails with N/A despite the fact that I have values. Have a look in screenshots how can i solve it
See File
-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
...