4,550 questions
1
vote
4
answers
129
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($K$3)),2)
where F74 contains the grade I want to ...
- 89
0
votes
1
answer
75
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 ...
- 155
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
95
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 ...
- 95
0
votes
1
answer
109
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'!G$3:J$2000,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 ...
- 1,645
0
votes
1
answer
68
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 ...
- 11
0
votes
2
answers
116
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 ...
- 11
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 ...
- 785
-1
votes
1
answer
108
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 ...
- 29
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 ...
- 11
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
...
- 13
1
vote
2
answers
93
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
112
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 ...
- 785
0
votes
2
answers
78
views
Return nth value in multi criteria vlookup
https://docs.google.com/spreadsheets/d/1jb9dKFAEL2IWP5C1z5S3cEKol27vYqcsISh1l16KlLQ/edit?usp=sharing
I have created the above Google sheet where I am doing a Vlookup in col. A to return Vlookup value ...
2
votes
1
answer
114
views
How can I count the datas using Countifs and Lookup in google sheet from a different sheet
I'm having issues with getting the result using my code from different sheet.
Here is my project:
Date
Agent
Status
02/01/2025
Rey
Valid
01/01/2025
Rey
Invalid
03/02/2025
Paul
Valid
04/03/2025
Rey
...
1
vote
0
answers
36
views
Is there a way in Tableau to go through a series of numbers in a field (delimited by ",") then do a lookup for each from another data source?
I have a series of IDs in a Tableau column that I need to derive the actual names from another data source (like a vlookup or join via the ID), and display the actual names on a new Tableau field. See ...
- 31
1
vote
1
answer
58
views
Tracking variable name changes within group in Excel
I am annually tracking the names of car models, which may or may not change each year (its random).
Suppose I start with three models in 2023 that all changes name in 2024 and 2025, thus producing the ...
- 153
0
votes
0
answers
46
views
vlookup Formula will not return a value
In cell A5, I am trying to reference the 1st 3 numbers of a cell A1 to vlookup a value in a table in columns C:D. When I run the code separately, it works great. Once the vlookup and the left ...
0
votes
2
answers
83
views
Get list of items that cause Vlookup failure and error
I am working with family history data and need to ascertain the Sex from the Given Name.
I built a lookup table of given names and usual Sex but it occasionally fails due to a missing or unrecognized ...
- 3
1
vote
1
answer
60
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 ...
- 11
0
votes
0
answers
67
views
How can spotfire add a calculated column in data table with lookup function
I want to add a calculated column in my data table, but I can not find the function lookup function in expression function.
Layer ID
OVLTR
MT
Result
Cell A
NULL
MT_1
Cell B
Cell A
MT_2
Cell C
Cell A
...
- 1
0
votes
1
answer
86
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 ...
- 61
0
votes
1
answer
89
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
206
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
1
answer
78
views
Combine IF for text with INDEX and MATCH? Or VLOOKUP? QUERY?
Coming back to the best source I know to ask for help with something I'm trying to do for our little school. I have one sheet where I enter the date and the name of the student under what they're ...
- 15
3
votes
3
answers
140
views
Excel VLOOKUP Doesn't Recognize Identical Cells
I'm experiencing an issue with Excel's VLOOKUP function returning "N/A" despite cells looking identical. Below is an example of my sheet
The formula in cell B1 is:
=VLOOKUP(A1, A4, 1, FALSE)
...
- 53
0
votes
2
answers
95
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
43
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
1
answer
51
views
Lookup values to new columns like vlookup
In Power Query, how can I lookup and fill the values "?" which I highlighted in yellow.
I need to fill the columns F G H, based on A&B (or Textjoin column). In short, I need to fill the ...
0
votes
1
answer
60
views
Three-dimensional referencing
I have a dataset that looks roughly like this:
I'm trying to make a simplified table that pulls from that dataset:
Looking at just Column D in my simplified table — the goal is to return the "...
- 219
0
votes
3
answers
206
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
-1
votes
2
answers
116
views
Pull data from one Sheet to another Sheet based on the Header names, headers in different order
I can't believe I can't figure this out but I keep getting errors.
Example sheets are found at: https://docs.google.com/spreadsheets/d/1q4qRgXSq6xXhddArPCoBIuOOupRvokUd0andADCNN0Q/edit?usp=sharing
'...
- 67
0
votes
1
answer
78
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
2
answers
77
views
Copy based on different cell info in Sheets
I have a workbook for a school where on one page I have a list of several hundred names, emails, grades, and other info that is generated automatically by Canvas when a student takes an exam. I also ...
-1
votes
1
answer
88
views
Google Sheets ARRAYFORMULA with Partial Match and Multiple Criteria Not Returning Expected Results
I’m working with a Google Sheets document where I need to look up values based on multiple criteria and perform a partial match search in one of the columns. I’ve been trying to use an ARRAYFORMULA ...
- 23
0
votes
1
answer
49
views
How do I sum the 7 cells beside a correct match using Vlookup?
I have two Google Sheets. One is a list of dates in sequence in Column A (9/1/24; 9/2/24; etc..) and in Column B are number values associated with some of the dates.
Sheet 1:
9/1/2024
9/2/2024
...
0
votes
1
answer
1k
views
Google spreadsheets "VLOOKUP evaluates to an out of bounds range."
I can't seem to get VLOOKUP to work on google spreadsheet.
To my understanding, it should search for c, then return the value on the column to the right since index=2. I will note that when I plug in ...
- 14.9k
0
votes
1
answer
44
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
0
votes
1
answer
106
views
Vlookup for items in a comma separated list
I have a table with different values associated with different name.
Column A
Column B
height 1
2
width 1
5
height 2
8
width 2
9
In another sheet, I have a table with multiple values separated by ...
0
votes
2
answers
54
views
Iterate merge/VLOOKUP over multiple dataframes
I have multiple dataframes that I want to apply the same merge to.
data_1 = [[1, "Sarah"], [2, "Kevin"], [3, "Mark"]]
data_2 = [[1, "Bart"], [5, "Nina"...
- 51
0
votes
0
answers
36
views
=vlookup using two Excel files
vlookup in Excel
=VLOOKUP(A3,[Q_Joining_Demograph_Network_08.14.24.xlsx]Sheet2!$A:$A,2)
is throwing a #REF! error in the cell.
tried using data>text to columns thinking the to columns are not the ...
0
votes
1
answer
63
views
VLOOKUP but instead of matching data, just mark X? [closed]
I have data in sheet 1 and sheet 2.
I'm trying to use a MATCH/INDEX/VLOOKUP formula, to find data in another column.
HOWEVER - instead of retuning the value or matching - I Just want to mark an X (or ...
- 1
0
votes
0
answers
74
views
Using TEXTJOIN and nested IFERROR/IF functions
I am trying to use TEXTJOIN together with IFERROR and IF to look up values from other tabs and combine (where relevant). The first tab might not have value to receive and in which case want to get ...
- 1
-1
votes
1
answer
67
views
Which of these two ways is the correct one for using VLOOKUP? [closed]
This is a question to give an end to a discussion between me and the rest of my work friends, since we use the VLOOKUP formula differently. Can anyone help us?
Basically, when I use this formula, my ...
0
votes
1
answer
38
views
Create a formula that gathers information from one sheet and inputs it in another based on one cell
I have two spreadsheets. I am scanning items onto sheet 2 under column A.
On Sheet 1 I have all the information for Inventory. The Columns I will be using from sheet a is Column D and Column AA. So ...
- 49
-1
votes
1
answer
274
views
Excel - How to calculate the return value when the lookup value falls between two values in the lookup array
Assume I have this lookup table:
Column A
Column B
60%
10
70%
9
80%
8
90%
0
100%
0
110%
0
And the value I want to match is 65%
I'm trying to find a formula that will give me the number that's in the ...
0
votes
0
answers
92
views
Entered too many arguments for this function
I am having a problem where I am unable to find out the issue with my formula in Excel. Everything worked fine until I added an additional argument to the string, but I do not see any erroneous commas ...
