All Questions
3,404 questions
0
votes
0
answers
54
views
How to get the exact Team Name using Application.VLookup
Sheet1
Error during initialize:
What should be fixed in the code below to get the exact team name populated in the Me.cmbTeam.Value (combobox) if team member is matching in column 2.
Private Sub ...
- 749
-1
votes
1
answer
46
views
How can I use Excel VLOOKUP function based on specific text and not displaying all columns [duplicate]
How can I use VLOOKUP to display data from Sheet A to Sheet B based on one specific value in Sheet A cell D5. The specific value will be also located in Sheet B Cell A1.
I have tried using something ...
- 27
0
votes
0
answers
105
views
I'm getting getting vlookup to work correctly in VBA
Dim monitorRange As Range
Set monitorRange = Intersect(ws.Range("A:A,D:D,G:G,J:J,M:M,P:P,S:S"), ws.Range("16:30,42:56,68:82,95:109,122:135,147:161"))
cell.Offset(0, 1)....
1
vote
2
answers
78
views
Returning Max Value Using Vlookup with Multiple Results
Trying to work on a VLOOKUP formula for a calculator that I am working on that returns the highest value from column B where columns A = True. Unfortunately what I am getting with my current attempts ...
- 421
1
vote
3
answers
86
views
How to display items in listbox using VLookup from another sheet in VBA
I have here Sheet1 that contains dynamic items from Columns A to D. I have Column D with Teachers names but also blanks in it. I also have Sheet2 that contains Teachers names. I would like to display ...
- 749
0
votes
2
answers
64
views
Get list of items that cause Vlookup failure and error
I'm only getting back to VBA and was never an expert so thank you in advance for your patience and understanding.
I am working with family history data and need to ascertain the Sex from the Given ...
- 3
1
vote
1
answer
38
views
Excel: Using Index/Match Functions Instead of Vlookup
enter image description here
Could someone help me turn the following equation in Column I into one where it does not use Vlookup but rather Index/Match functions and gives me desired result please. I ...
- 13
0
votes
1
answer
69
views
VBA Hide Rows in Sheet Based on the Vlookup Value in a Named Range
I have a VBA Sub that is supposed to lookup values from a Named Range and if it finds a match, hide a certain number of rows. But it's not working. In fact, it's producing results that I don't ...
- 41
0
votes
1
answer
62
views
Lookup matching cell in a table and return the value of the first cell that's merged upwards to the matching cell
Good day,
I have a spreadsheet with a manually populated table (B:D).
Then, I'm attempting to create an extract from that table based on the values from column B according to the value from cell I2. ...
- 57
-4
votes
1
answer
64
views
Conditional formatting using vlookups and dates
I’m trying to set up conditional formatting that uses vlookup to check a date against a tag, and if that date is less than a specific date, highlights it green. See attached data as example.
In the ...
0
votes
2
answers
70
views
Vlookup the equivalent value if it matches or fits inside a range [duplicate]
How to VLOOKUP the equivalent value if it matches or fits inside a range. Is there a way to get this using vlookup?
Normal VLOOKUP and INDEX/MATCH formulas are not working.
The Excel file I currently ...
0
votes
0
answers
39
views
Select data from one sheet to another based on date and other criteria, getting repeating results
I have a spreadsheet with multiple entries encompassing a variety of parameters. My query seems to be working a bit, but is creating a lot of duplicate entries that are not in the original data set.
...
0
votes
3
answers
121
views
How can I use excel functions to identify whether an enter date is a holiday?
Hi,
I have a dataset that includes all weekdays, displayed in blue, and another dataset containing holidays from 2024 to 2026, shown in green. I would like to identify which dates in the weekdays ...
- 13
0
votes
1
answer
64
views
Excel Formula changes values after a day or so
I have a bunch of text strings separated by commas in a cell (e.g., in COLUMN A here).
Column A
Column B
AA,AB,AC
??
AC,AZ,BB
??
AB,BB,CD
??
Each one of these texts is associated with values in a ...
0
votes
1
answer
38
views
How to return top X unique values in a column by the condition in another column
I am trying to return top selling companies for different conditions (size) and top selling companies' price in the table F:J. I need to do this for multiple reports with thousans of rows of data, so ...
- 1