4,549 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
4
answers
130
views
Why doesn't getting a value from a named range work, only for this specific value?
I have a named range called A2Bounds25:
Grade
Percentage
A*
80
A
71
B
60
C
49
D
38
E
27
I pull the percentage from A2Bounds25:
=VLOOKUP(F74, (INDIRECT($K3ドル)),2)
where F74 contains the grade I want to ...
0
votes
1
answer
77
views
Excel: Need to look up a random value in a row next to a corresponding entry and return a result in another list
I normally try to figure these our or my problems don't have that much complexity, but trying to create a list for testing. The list will have 4 unique values that are considered the attribute and ...
2
votes
2
answers
156
views
Convert from iferror vlookup to VBA's dictionary array
I need help with a repetitive task that I use vlookup for huge dataset, a bunch of tables of >1 million rows from multiple columns, multiple sheets of another workbook.
ID
TA
ISRC
Result
ID1
TA1
...
0
votes
3
answers
99
views
Excel: VLOOKUP/TEXTJOIN to get comma-separated result in cell for multiple matches in comma-separated cells in a column
I am trying to match a single value in a cell with content of a comma-separated list in a cell in multiple rows and get all matches returned in a comma-separated list.
The source data sheet format ...
0
votes
1
answer
115
views
Can You SubTotal a Column that contains formulas, but Ignore Unanswered Formula?
I have a column of data that is populated by a Vlookup.
=IFNA(VLOOKUP(A9,'STRUCTURAL E3D DATA'!G3ドル:J2000,3,ドルFALSE),"")
I need to sub-total this column, but without it just counting all the ...
1
vote
4
answers
246
views
VLOOKUP with a WHERE condition on separate column
MY DATA
I have the following sheet of data, data:
PERSON
TEAM
Lookup
COUNT
FOO
A
Y
3
BAR
A
N
1
BAZ
A
N
4
FOO
B
N
1
BAR
B
N
2
BAZ
B
Y
5
FOO
C
N
3
BAR
C
Y
1
BAZ
C
N
2
MY INTENDED FINAL RESULT
I want to ...
0
votes
1
answer
69
views
Inconsistent behavior opening a file in VBA Excel
I am trying to call a function in Excel in one file using a vlookup from another file. The code works correctly if I am using it from the sheet that has the lookup table. However, when I run it from ...
0
votes
2
answers
119
views
VBA Excel vlookup similar strings
I have a vlookup imbedded in VBA that is giving me difficulties.
Here is a sample table:
Body
Group
Other Stuff
Sun
Star
Other Stuff
Jupiter
Planet
Other Stuff
Io
Moon
Other Stuff
85 Io
Asteroid
Other ...
0
votes
1
answer
81
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 ...
-1
votes
1
answer
109
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 ...
0
votes
3
answers
85
views
VLOOKUP to find average values for duplicate ranking from ranking table
I have two Google Sheets with following data. I want to get average of two values from lookup table if I have duplicate ranking in my target sheet. How do I achieve this using VLOOKUP function?
...
0
votes
1
answer
29
views
Find the difference between each unique title per quarter
I'm trying to display the difference in quantity between each title based on each quarter. Here's the sample table:
enter image description here
I'm able to display each title by quarter, but I'm not ...
0
votes
0
answers
120
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
1
answer
66
views
Combining Sum with Vlookup
I have this data (table 1) :
Column A
1999
5000
6666
And there's table 2 :
Col.C | Col.D (range)| Col.E (margin)
1000 | 1000 - 1260 | 830
1261 | 1261 - 1261 | 0
1262 | 1262 - 1513 | 830
...
1
vote
2
answers
96
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 ...