All Questions
18 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
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
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
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
1
answer
392
views
Remove two or more words in a cell based on lookup value
I want to remove the words "FaKe TaBLet" in B2 into a new desired results like in C2, which is 'great number two' using (as far as I know) Reverse partial lookup or other formula instead of using '...
- 85
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.
...
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
3
answers
1k
views
vlookup using two columns names in different worksheets
I have one workbook, with two separate worksheets. I want to know if the values that appear in worksheet B also appear in worksheet A, if so, I want to return a "YES". If not, I want to return a "NO". ...
- 31
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
1
answer
748
views
using an Array formula to do VLOOKUP in multiple sheets
I have used below formula in this file but I do not know why it doesn not work and return #N/A!? Infact I need to lookup "Station .No" from other sheets to display it in Sheet1 :
= VLOOKUP(I3,...
- 173
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
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 ...
2
votes
1
answer
74
views
Not getting desired output with VLOOKUP - Need assistance
I have Table 1, which looks like this -
A1 B1 C1
1 X Date11
2 Y Date12
3 Z Date13
I have another table, Table 2, that looks like this -
A2 B2 C2
1 M Date21
2 N Date22
3 X ...
- 33
-1
votes
1
answer
287
views
Excel Vlookup range or if function
I have been struggling to find a formula that works for the example below (see question mark!). What i am trying to do is merge 2 datasets. The problem is that the common identifiers are not always ...
0
votes
1
answer
127
views
Merge multiple tables by comparing multiple rows
I have multiple three column tables that share two rows in common:
DailyCosts: DailyPrices
CodeRole CodeRegion DailyCost CodeRole CodeRegion DailyPrice
1 1 ...
- 103
1
vote
1
answer
538
views
In Excel 2007 does the data from a formula referenced in another cell get used, or the formula itself?
Simple question and more than likely a simple answer.
I have a workbook with a few worksheets, one of which is a 'data' worksheet. This information is utilized on another worksheet 'main' to fill in ...
- 646
1
vote
1
answer
9k
views
Excel IF and VLOOKUP function help
The exercise is to use IF() and VLOOKUP() functions to return the tax rate based on the annual income and number of people in the household.
So far I've tried inputting:
=IF(AND(B$2=3,C$2<=35000),...
- 21