All Questions
38
questions
0
votes
1
answer
296
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
114
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
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
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
2
answers
445
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
1
vote
1
answer
350
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
0
votes
1
answer
2k
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
159
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
0
votes
1
answer
93
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
240
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
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
104
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
1
answer
343
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
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 ...
