All Questions
Tagged with worksheet-function vlookup
216
questions
0
votes
2
answers
269
views
From an Excel list of event attendees spanning 10 years, how do I create another list that pulls the first year of attendance for all my attendees?
I have a list of guests that come to my events. The list contains 10 years worth of guest check-ins in order by date (ascending). Based on this list, I want to create another list that shows the year ...
- 1
0
votes
1
answer
2k
views
File name on the basis of cell value in vlookup
Currently, I am using vlookup as per the below:
This is in Cell M3 of main book:
=VLOOKUP(L3,'C:\Users\vp\Desktop\xcl\day_data\[5460993.csv]5460993'!$A:$C,3,0)
The value in Cell Z3 of the main book ...
- 21
0
votes
1
answer
46
views
How can I compare column values from two different work sheets?
I have two different Worksheets (A and B), both of which contains the columns PackageName and PackageVersion, both Column B and Column C respectively in each worksheet. I would like to have a third ...
0
votes
2
answers
89
views
Return Specified Values From Another Sheet
I have two Excel sheets open. The first sheet has data organized by Student ID and by School (two different column). In the second Excel sheet, I simply want to return a column that shows the Student ...
- 13
1
vote
3
answers
4k
views
VLOOKUP record with latest date
I'm creating a spreadsheet to monitor the last time we contacted a customer. In tab "Overview" I have a list of all the customer names and addresses for example:
A
B
C
D
E
F
Name
Address
...
- 25
2
votes
1
answer
2k
views
Excel: Get sheet name from Drop down Cell for formula
I have sheets each with an employee name.
I have a Summary Sheet that gets the weekly total from each employee sheet using VLOOKUP.
On the summary sheet, I have a drop down cell with all employees ...
- 23
1
vote
1
answer
37
views
Excel Lookup from different sheet
i have sheet in below formats
Sheet1
Sheet2
Now i have to validate my Sheet1 as per Sheet 2 if ID exist and country present its "Match" else "No Match" if no entry then "No ...
- 95
0
votes
2
answers
427
views
If VLookup Function that add corresponding cells if 1 range matches another
If B4 matches a # in column A I need the formula to return the # in column C and then add...
For example: Since B4 matches A1, I need C1 (90) +E1 (3) + F4 (0) and return the value in C4.
I tried this, ...
0
votes
3
answers
1k
views
Excel VLOOKUP for range of dates
I have been struggling with VLOOKUP for sometime. I want to use VLOOKUP for a range of dates using the two tables I have given. I want to get which Term each row belongs to. Basically I want to check ...
- 101
1
vote
1
answer
303
views
How do I count multiple levels of referrals (A referred B, B referred C, D & E, E referred F, G, H, I, etc)?
I have a referral system where you get credit for referring other customers. If those customers refer other customers they get some level of credit for those as well. We need to count not only how ...
- 119
1
vote
1
answer
646
views
Copying cell colors to another sheet
My active sheet (let's call it Sheet1) will be main for all users to edit and view.
User 1 only needs to view half the data in Sheet1 at a time so I've created a Sheet2 to only display the data that ...
- 11
0
votes
2
answers
7k
views
return yes or no based on cell data from another sheet
I have two sheets.
The first sheet "Example A" and the second sheet "Example B".
Example A has a master sheet of clients that may also be on Example B. If the client is listed on ...
- 1
1
vote
1
answer
386
views
Excel - Concatenating cells returned through looking up against duplicate values
I have a unique problem that I have been unable to solve and hoping to get insights from the experts here. I have the below table:
Sprint ID# Description
1 ABC
1 XYZ
2 ...
- 11
0
votes
3
answers
3k
views
Is there an option or setting that prevents VLOOKUP from returning zero when it finds blank cells
Is there an option or setting that prevents VLOOKUP from returning zero when it finds blank cells or does not find the lookup value.
I do not want to suppress the zeros by formating them out. I want ...
0
votes
1
answer
3k
views
Increment the cell in Vlookup when dragging horizontally in Excel
I have a Vlookup formula in excel
=VLOOKUP($A2, Kenya!$A$2:$L$34,2,FALSE)
I'm trying to drag this formula in columns (to right side of the sheet) and I want the the row of the lookup value to ...
