All Questions
15
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
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
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
1
answer
362
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
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.
...
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
746
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
73
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
0
votes
1
answer
412
views
Copying VLOOKUP formula in multiple sheets, where sheet number automatically changes
I have created a progress card in Excel (there are 50 such sheets, one each for 50 students). There is one tabulation sheet also with the names of the 50 students. So, when numeric marks are entered ...
- 1
1
vote
1
answer
534
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