All Questions
Tagged with worksheet-function vlookup
216
questions
12
votes
3
answers
399k
views
Searching for a value in Excel, returning yes or no
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". ...
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 ...
4
votes
2
answers
399
views
Excel vlookup reference purposely missing shows #N/A - stop it
I have a cell which does a vlookup.
But the table to which it refers is always changing and when the specific value is there is shows fine.
But when the value isn't there it shows #N/A - how can I ...
4
votes
2
answers
1k
views
How can I combine VLOOKUP within an IF statement where the column index of the VLOOKUP function is a number extrapolated from a text?
I have the following tables in Excel:
and
.
The product Stock table (PST) is more extensive than this but for the purposes of this question I have cut it down.
I want to lookup the value in a ...
3
votes
3
answers
3k
views
Using VLOOKUP for multiple lookup values, then summing the outputs
Example:
I have a sheet listing the number of calories for various foods.
In another sheet I have a list of some of those foods to be used in a meal, and would like to calculate the total number of ...
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 |
...
3
votes
1
answer
5k
views
Excel - Increment vlookup column index when dragging down
I have a vlookup which needs to check the next column to the right each time it is dragged down a cell. So if the vlookup is first entered in cell A3 then it would be:
=vlookup($A$1, $A$1:$E$1, 2, ...
3
votes
1
answer
5k
views
Single named range over multiple sheets in same Excel file?
In Excel, is it possible to name a range that exists over multiple tabs?
For example, I have a range B3:C20 in sheets Tab 1 and Tab 2
I tried to name a range NamedRange1 that referred to
='Tab1'!$...
3
votes
1
answer
2k
views
Excel: Why is VLOOKUP returning inconsistent and unexpected results?
I'm automating an Excel column to assign account values based on the vendor paid. For instance, if AT&T gets paid, the account value is Utilities:Telephone, and when the post office is paid, the ...
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 ...
2
votes
2
answers
87k
views
Looking-up the values of one worksheet in another worksheet
Basically, I could do this manually, but as the data is huge, it would take a lot of time. I am sure there must be a formulaic way of doing it.
I have two worksheets in Excel.
Worksheet 1.
Column-A ...
2
votes
1
answer
2k
views
Excel: Get sheet name from Drop down Cell for formula
I have sheets each with an employee name.
I have a Summary Sheet that gets the weekly total from each employee sheet using VLOOKUP.
On the summary sheet, I have a drop down cell with all employees ...
2
votes
1
answer
822
views
Return and sum multiple values using a wildcard criteria
I'm trying to create a complex formula that does the following:
Looks up data in column A of another sheet using a "contains" criteria (xxxx&"*")
Returns all matching values from a specific ...
2
votes
1
answer
228
views
Lookup value in a row based on keyword
I'm trying to lookup a value in a row based on a keyword and return the value.
Example:
Column 1 Column 2 Column 3 Result
http://1stexample.com http://...
2
votes
2
answers
1k
views
Excel - return multiple values for each of a list of values
I've been trying to solve this for a good few hours now, but with no result...
My setup:
I've got excel sheets of cosmetics product recipes.
Each recipe contains dozens of ingredients, each given by ...