All Questions
Tagged with microsoft-excel-2016 vlookup
14
questions
0
votes
1
answer
377
views
Combining an Excel IF Statement with VLOOKUP
I have the following if statement in Excel:
=IF(VLOOKUP(AB2,AD:AD,1,0)=TRUE,1,0)
What I am trying to do is say the following:
"If the results of the VLOOKUP return any value other than "#N/...
0
votes
1
answer
57
views
Sorting and ordering two expense lists by a third list of categories using Excel 2016
I want to use Excel 2016 to sort two expense lists by a third list of categories.
The first catch is that I want to place the value in the same cell like the categoris list – It's not a simple sort, ...
- 147
-1
votes
1
answer
67
views
How to combine table 2 sheets (ข้อมูลตัวอย่าง1 and ข้อมูลตัวอย่าง2) to new table 1 sheet (Use VLOOKUP formula with multiple condition)?
I have data in Excel file to combine table 2 sheets (Have data with web : https://www.contextures.com/xlSampleData01.html)
How to combine table 2 sheets (ข้อมูลตัวอย่าง1 and ข้อมูลตัวอย่าง2) to new ...
1
vote
2
answers
173
views
Unsure if vlookup, hlookup or index match needs to be made to fill out values in a X,Y,Z mesh
I would like some help with an an Excel formula as I am unable to infer if I need to use hlookup, lookup or index match for this.
I have 3 columns of data but how can I create a X, Y, Z mesh. How can ...
3
votes
2
answers
87
views
I want to count IF both condition are true Logically count by AND excel
I have two Columns both are categorical columns. Like Age_group and Engagement_category.
And I want to get count no. of each engagement_category in each Age_group.
| Engagement_category | Age_group |
...
- 171
0
votes
1
answer
103
views
Vlookup or index/match to match a value to the left side of the numbers in a column
I am trying to figure out a way of performing a vlookup for a given value. The value I am looking up in correct in its form (six character number). But the values in the column that i am trying to ...
- 1
0
votes
1
answer
224
views
Excel - Vlookup within Vlookup dependent on drop-down
Please bear with my explanation here - I want to be as clear as possible. I have about 8 different tables (different categories), which contain ranges that correspond to point values. I have been ...
0
votes
1
answer
92
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
2
votes
1
answer
70
views
How can I lookup a value in a column for multiple rows?
I have a table with a column giving week number (1-52) in Column A, and I would like to get an average of all items listed in Column D of the same table. So every week is represented by 5 rows.
The ...
0
votes
0
answers
220
views
Matching two columns in Excel
I am having trouble getting excel to match two columns.
I have 3 columns in total, 1 is blank, 2 contains a list of companies and 3 contains another list of companies.
I want to match column 3 with ...
- 23
2
votes
1
answer
411
views
Using VLOOKUP to retrieve data in separate sheet based on value
I have long account codes separated by dashes so they look like ##### - ### - ## - ######. One of these dashes that separate the numbers is a departmental code. In my workbook I have a sheet called "...
- 33
0
votes
1
answer
297
views
Using VLOOKUP across worksheets without referencing the original worksheet
I've got a workbook that runs a few macros to pull in copies of sheets from a number of other workbook. I'm trying to set up one file that users can copy to their project folders and then just use ...
0
votes
2
answers
375
views
Explanation for a VLOOKUP formula used in a Conditional Formatting rule
I have the following VLOOKUP formula for a Conditional Formatting rule:
=VLOOKUP(A1,Sheet1!$A$2:$C$17,3,FALSE)<>0
This works fine and does what I want, which is this: If column C (3rd column) ...
- 486
6
votes
2
answers
9k
views
Range mapping in Excel
I have a column of data in Excel with numbers [0..100]. I need a new column, which maps these to a new set of values such that:
> 90 : 4
80-90 : 3
70-79 : 2
60-69 : 1
< 60 : 0
I attempted to do ...
- 225