All Questions
Tagged with vlookup microsoft-excel-2010
74 questions
0
votes
1
answer
542
views
How to Autoincrement the Column index number by dragging VLOOKUP formula down
I need to drag a Vlookup down and have the Column index number in to increase by 1 every row I drag it down.
So for example:
Row 1:
IF(VLOOKUP(A2,'Jan 2024'!$D:$BP,**35**,0)<=0,"IGNORE",...
- 1
0
votes
1
answer
196
views
Is there a formula for retrieving data from multiple cells on a different spreadsheet and adding to one single cell on another spreadsheet?
I am working on a project in which I need to retrieve the Parent Items for a list of scrap material. The problem is that most of this material is used in multiple Items. When I run a separate report ...
- 13
0
votes
1
answer
366
views
Get VLOOKUP "lookup_value" to refer to a cell reference?
I have this table in the top-left of my sheet:
I want to point VLOOKUP to cell A2 above, so that it returns 2. How can I achieve this? This doesn't work:
// this outputs 1, not 2.
=VLOOKUP(A2,A1:B3,2,...
- 233
0
votes
2
answers
477
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
2k
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
410
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
2
answers
508
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
0
votes
1
answer
137
views
Excel - Look up on multiple tables - complex
I am trying to make it so that my operators can cut and paste information into an Excel spreadsheet, and then I will have a Vlookup, etc. to be able to get the information I need. The problem is that ...
1
vote
1
answer
399
views
EXCEL - How to use VLOOKUP to get the entire table contents?
I have an Excel sheet with columns:
Screenshot
Data
Table 1 Table 2
METADATA Date ...
- 113
1
vote
0
answers
60
views
How to search for and return all records between two dates?
I'm not sure if this is a lookup formula I need. Basically, I have a huge spreadsheet with the travel details of lots and lots of groups. Each row is a different group. For reference, Column K shows ...
- 11
0
votes
1
answer
3k
views
Need formula to vlookup comma separated values in a single cell
I'm trying to do a vlookup on a cell with comma separated items in it for the lookup_value, referencing another file that has 1 item per cell. My example below has 6 items in the csv cell, and i want ...
- 3
0
votes
2
answers
203
views
Advanced VLOOKUP based on the value of two separate drop down lists
I have a spreadsheet with a summary page containing a selection list for week and a selection list for the portfolio. The workbook has the portfolio data on separate tabs. What I require is data for ...
- 113
1
vote
0
answers
16
views
Cannot lookup value and create conditional formatting in excel 2010
I have one worksheet which has in the A column product sku and at C D E columns supplier names.
Each supplier has its own worksheet which has again product sku price and availability.(suppliers ...
- 111
-1
votes
1
answer
79
views
How do I assign a number cell to a text cell
I have imported data from the web on the Peruvian Football League which will refresh and update. I have taken an average % of 2 samples of data for each team. I also have a fixture list and want to ...
0
votes
1
answer
105
views
Filter Out Values by Category into new Table with vlookup
I have the following data that contains a list of Agents and their respective Manager:
I need to filter out the agents by manager and put them into a new table for each Manager?
I tried with the ...
- 125
0
votes
2
answers
253
views
EXCEL: How do I find and match 2 different lookup values that are in separate columns?
I have two tables. one with 2 columns and the other with 3 columns.
T1C1(table1&column1) have mix of T2C1 and T2C2. I need to match T1C1 with T2C1&T2C2 and return the T2C3 values to T1C2.
...
0
votes
1
answer
662
views
How to "lookup" in a matrix in Excel where only column reference is specified
I have to search a given date which is either present or not present in a matrix, and where only the columns are specified. I need to go to specific column (name on top of column), and find in the ...
- 3
0
votes
1
answer
3k
views
VLOOKUP with multiple returns vertically
I am creating a form on worksheet 1. I want to enter a name in cell B1 and for it to look up a list which is on worksheet 2, find the name and return the values from the cell next to the name all down ...
user710023
0
votes
1
answer
180
views
Excel 2010 : vlookup - How to create a column automatically?
I have two sheets (let's call them : Sheet 1 and Sheet 2), each one have a table with their own fields.
How can I add this new column with the values ?
If I refer to VLOOKUP documentation :
...
- 105
0
votes
0
answers
105
views
VLOOKUP Excel general references
I have a VLOOKUP table in SHEET2 where the values in the body of the table are as a result of some complicated formulas taking data from SHEET1. I have set up the table with the formulas associated ...
- 37
2
votes
4
answers
428
views
Is it possible to use Index and Match or something similar in Microsoft Excel to find last filled number row for two sets of numbers in same column?
Sample table image:
Objective:
In the sample table image, I want to extract from column C, last populated CST number as 1235 and last populated Vat number as 204.
If i use =VLOOKUP("CST",B2:C5,2,...
- 21
2
votes
1
answer
349
views
VLOOKUP or INDEX-MATCH formula for database
I am currently working on merging 2 databases. Information has been altered for example purposes.
In the top spreadsheet, I have all the information that I will be needing. In the bottom is the ...
- 43
1
vote
2
answers
2k
views
Excel 2010 VLOOKUP #N/A Result when numbers are in different number formats
Using a VLOOKUP function and the lookup value may be something like 100034 and when I click on the cell it tells me it is of the "General" format. Where the lookup value is located in my data range ...
- 179
0
votes
1
answer
411
views
Excel Index/Vlookup - Search Column for ABSOLUTE closest or exact value and highlight
I'm new to coding in Excel, so I apologize in advance if this sounds like something I should all ready know. VERY new!
This is what I'm trying to accomplish:
In, let's say, Cell A1 I have a ...
0
votes
0
answers
162
views
Effeciently Vlookup Values 400k rows x 10 columns - Arrays?
Thank you in advance for helping me with this. I have a dataset (400k rows x 10 columns) that I need to lookup values for in another workbook on 5 different tabs. How should I set this up for maximum ...
- 11
1
vote
0
answers
26
views
How do I copy a row of values to another tab if a specific criterion is fulfilled?
I have two tabs with identical tables except one of them is supposed to contain those records that matches one of two values in one of the columns.
What I want is that whenever I add a new row to ...
1
vote
2
answers
275
views
Excel Index Match or Vlookup and copy
I have a sheet 1 with 3 columns as shown below. I have another sheet named sheet 2 with only the first names in Column A that are the same and found on sheet 1 column A.
I would like to write a ...
- 33
0
votes
1
answer
205
views
Using a Column Name in a VLOOKUP
I have a spreadsheet that takes data from the other 52 spreadsheets and totals it.
The columns in the sheet correspond to the names of the other spreadsheets (using dates, i.e., 01/01/2017 column ...
- 103
0
votes
1
answer
478
views
Compare Data from one worksheet to another and fill in the match
I need some assistance with Excel 2010. I would like to find a quick way to assign tickets, but not change previous ownership.
For example: I would like to compare my current list of unassigned ...
0
votes
1
answer
55
views
Excel Vlookup #N/A error
I need the cell to show blank if the following conditions aren't met but excel is returning an #N/A value.
=IF(ISBLANK(O14),"",(IF(AND(C14<>"OFF",$B$2="Week 1"),...
1
vote
1
answer
2k
views
Referencing a dynamic, named range between workbooks
I inherited this data structure. I have a bunch of products and their supplier information laid out as so:
Supplier Order Number Name Cost
ACME 00123 A 1
ACME 00321 B ...
- 330
0
votes
0
answers
150
views
Two identical values not treated equally in Excel
Was trying to use a simple VLOOKUP on a table with some calculated values (using formulas). It couldn't do exact match, even though the lookup value is equal to the table value. But copying the needed ...
- 385
1
vote
1
answer
3k
views
VLOOKUP for latest non-empty cell
Basically, I've got the following spreadsheet.
There are dates along the top. I do a certain amount of past papers each week, and record the highest score I get in a week in cell (paper, week). The ...
- 13
0
votes
1
answer
41
views
Using a Date to refer to a page to VLOOKUP into
I currently have data that has a date and item number and I'm looking to pull the price from a different sheet.
=Vlookup(#,Jan1!(Range),2,0)
Gives me my price of Jan 1
=Vlookup(#,Jan3!(Range),2,0)
...
- 3
2
votes
1
answer
6k
views
Build a lookup query in Excel using named ranges stored in a cell
I have a spreadsheet which has a lot of named ranges, each of which is a table. I want to be able to run a lookup that will retrieve a value from any of the tables. I want to be able to store the name ...
- 21
2
votes
1
answer
39
views
Making one list from other data using a lookup
I have 2 columns of data in an excel sheet - Column A:A is an id number, and column B:B is a binary 1/0 response. I have > 1, 000 rows of data.
Example
0001 1
0002 0
0003 1
0004 ...
- 21
0
votes
1
answer
2k
views
How do I set a dropdown in excel to populate different data in cells below based upon the option selected from the dropdown?
I am attempting to clean up a spreadsheet that we have that tells us what permissions to grant for certain roles in our ticketing system.
I have used the Data Validation tool to create my dropdown ...
-1
votes
3
answers
544
views
EXCEL VLOOKUP returning #NA when IF condition specifies " "
=IF(VLOOKUP(D4,'[05.14_Wave 5 Priority 14 (Big+Cranberry) Specifications.xlsx]Big'!$B:$B,1,FALSE),"Project
BIG",IF(VLOOKUP(D4,'[05.14_Wave 5 Priority 14 (Big+Cranberry)
Specifications.xlsx]Cran'!$...
- 9
0
votes
1
answer
2k
views
Is there a way to exclude keywords in a VLOOKUP formula?
I have 3 sheets in Excel. In the 1st one there is a column with hotel names and another one with ID. I want to get that ID from the ID column on the 2nd sheet where I have the names as well.
The ...
0
votes
1
answer
59
views
Excel Formula Is unwantedly automatically changing
I have created a product referral log and needed to have a system that automatically calculates points for those products once they are closed.
My solution for this was to make a separate sheet ...
- 1
0
votes
3
answers
981
views
Excel multi table lookup, can you find a more elegant solution?
This is partly for fun, and I hope it doesn't get closed on subjectivity grounds because although "which solution is the most elegant" is subjective, "the current solution is convoluted and ugly" is ...
- 774
3
votes
2
answers
3k
views
Excel, how to use text functions on lookup array without putting in another column?
If I'm using a vlookup, or a match function but I need to do some mumbo jumbo on my lookup material, is there a way of doing this in the lookup array without simply adding another column?
Let's say I ...
- 774
0
votes
1
answer
668
views
Excel Index Match for multiple conditions evaluates correctly with F9 but not in cell
I have an index match formula that evaluates correctly if I use F9, however when I actually press enter it returns #N/A.
The formula is designed to perform a vlookup on two conditions:
=INDEX(Table2[...
- 101
0
votes
1
answer
67
views
How can I search for a value that's repeated in excel?
I have a spreedsheet (Sheet2) that has 4 columns:
ID | Name | Semester | SemesterAvg | Overall Avg | Period |
1 | John | 1 | 2.5 | 2.5 | 20132 |
1 | John | 2 | 3....
- 1
0
votes
2
answers
819
views
Needs VBA solution - Clear contents of 4 cells to left of cell with N/A Error
I have a table of data in which column L has a vlookup formula. In the rows where column L (i.e., the vlookup returns "#N/A"), I would like to clear the contents of the eight cells to the left (...
- 11
0
votes
2
answers
459
views
IF Statement with VLOOKUP
I'm trying to get a value from the ADD Taxable which is column 10 in the Check (sheet). I only want the value from column 10 if the Earn Type on Timecard (Sheet) has BONUS in it. I'm using the TC Ref ...
- 15
0
votes
1
answer
120
views
Excel 2010 - VLookup -
I have two identities associated with one unique value in the table. I need to pull both the values in another sheet using vlookup - is that possible.
Here is the example:
Id Owner Name
A1 Owner 1
...
0
votes
1
answer
101
views
How do i do a "tweaked" VLOOKUP?
So here is the problem: I have 3 lists (adjacent columns) in a spreadsheet.
The 1st list contains the values I am searching for
The 2nd list contains the first half of table array which I am ...
0
votes
1
answer
592
views
Searching for a value across 2 tables in Excel 2010, returning yes or no
I have one workbook with 3 separate worksheets
Sheet 1 contains 2 columns.
Column A has a range of unique alphanumeric identifiers.
Column B has a range of non-unique numbers.
A B
...
- 1
0
votes
3
answers
15k
views
VLOOKUP using CONCATENATE values [closed]
I have workbook1 with 3 values (columns) concatenated to 1 cell as =TRIM(CONCATENATE("ABC","-",$B174,"-",$A174,"-",$E174)).
Workbook2 has 1 cell that contains the concatenated value from workbook1.
...
- 11