All Questions
Tagged with worksheet-function vlookup
216
questions
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 ...
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 |
...
2
votes
1
answer
687
views
False Positive Matching Excel
Hi there I am having trouble with matching because it is showing me false positive match because everytime i enter for example another 14.33 it keeps saying match. What i need help with is find the ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
-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 ...
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. ...
0
votes
0
answers
58
views
Index/Match function to return all values based on multiple criteria
I have an Excel document where I am trying to list all values that match three criteria.
Sheet1:
Year Player Pos Cluster
2018 Joe C 1
2018 Ken RW 2
2018 Bill C ...
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 ...
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.