All Questions
201
questions
1
vote
1
answer
812
views
Excel VLOOKUP failure (#N/A) where equal test indicates a match
I'm currently getting
=VLOOKUP(D5,'Per payment&sub'!D$8:'Per payment&sub'!D$394,1,FALSE)
returning #N/A, where I was expecting a match. Have done the requisite googling, but all suggestions ...
- 13
0
votes
1
answer
85
views
Excel does pallet X in location Y physically match the system
I'm trying to physically validate pallet id's and locations compared to what our system indicates. There are two tables, one is exported data listing location and pallet id. The sheet with exported ...
- 1
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
107
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
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
230
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
89
views
Excel: comparing string values from different sheets that don't match exactly
I have a workbook with two sheets, each of which contains a list of people. If a person from Sheet 1 also appears on Sheet 2, I need to be able to flag them on Sheet 1. I've added a column where I was ...
- 170
-1
votes
2
answers
100
views
How do I do VLOOKUP or INDEX/MATCH for more than one range?
I have been trying to figure out a way to fill up the ratings column (image below) without getting into lengthy formula. I have tried VLOOKUP and 'INDEX/MATCH` but have gotten to a dead end.
In a ...
- 9
1
vote
0
answers
26
views
Excel - Reference Value where multiple conditions are met
I am finding it extremely difficult to translate a simple SQL Style Lookup into excel.
I have data spread about multiple excel sheets which I am trying to combine into one sheet/table automatically. ...
1
vote
2
answers
814
views
VLOOKUP, If exists use other value
Sorry, not too good with Excel, but what I am trying to achieve is this vlookup located in sheet1 cell R7:
=VLOOKUP(F2,config!F2:H20,3,FALSE)
Which displays a room number, e.g. 1
However, if the ...
- 157
1
vote
1
answer
101
views
Values in a column to rows based on multiple criteria
I am trying to turn a the table on the left side to the one on the right.
How can it be achieved? I have tried This, but it did not work.
- 113
0
votes
2
answers
25
views
Excel Lookups Multiple Columns Concatenated
I have a spreadsheet like this:
| hostname | key | value |
| host1 | tagA | abc |
| host1 | tagB | bcd |
| host1 | tagC | efg |
| host2 | tagB | hij |
| host3 | tagB | jkl |
...
- 111
2
votes
1
answer
264
views
How to use proportions with lookup tables in Excel?
The Min_Prop_of_As shows the minimum proportion of undergraduate students receiving a percentage grade of >=80. I only want to use the undergrad grades in cells C2:C15. How do I write a VLOOKUP ...
- 35
1
vote
3
answers
594
views
Index and match on multiple columns
I have the following dataset I am trying to re-sort to do a mailing merge with word. I need to suppress the empty cells and match the usernames in an array to the company name they belong to.
im ...
- 13
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 ...
- 31