Questions tagged [vlookup]
VLookup is a Microsoft Excel function that searches for a value in the left-most column of a table array (a range), and returns a value in the same row based on the column number from which the user wishes to retrieve the value.
491
questions
0
votes
0
answers
34
views
Vlookup with radar graph
i have a simple radar graph setup, 1 column for headings and 1 column for results. The graph works as normal until…
Id like the ‘results’ column to be auto filled using a simple vlookup formula. Such ...
- 1
0
votes
2
answers
48
views
Vlookup formula or something else?
I am trying to compare two separate columns from two different sheets. If the data on the Columns A match, I am trying to pull data from Column B within the first sheet and have it outputted on sheet ...
0
votes
1
answer
40
views
Vlookup with search and left to find partial string
I'm trying to use a vlookup to pull information from one sheet to another but the reference information is different. For this example I put it on one sheet to make it easier. The information is ...
- 25
0
votes
0
answers
41
views
Vlookup error with drop down
I have created an expense sheet with month drop down list.
When I choose months from January to November, the data shows correctly.
But for December, it's incorrect.
November:
December:
Sheet3:
[3
...
- 1
0
votes
1
answer
116
views
Max value from multiple criteria with VLOOKUP
I want to find and display the highest number based on a grouping. Column A has a group of names with an item number at the end. Column C has individual item names and Column D has a number ...
- 25
0
votes
0
answers
47
views
How to map value of a cell to another value, depending what it "contains" ? (not a full match)
I have a worksheet C1 with the following data:
A
B
sometext 21 oscar ABC john
sometext 22 foo XXX smith
sometext 23 lucy YYY pedro
sometext 24 bar ZZZ edward
In another worksheet C2, the ...
- 911
0
votes
1
answer
28
views
Is there a formula for retrieving data from multiple cells on a different spreadsheet and adding to one single cell on another spreadsheet?
I am working on a project in which I need to retrieve the Parent Items for a list of scrap material. The problem is that most of this material is used in multiple Items. When I run a separate report ...
- 13
0
votes
1
answer
33
views
Populate rows (year listing) based on drop down selection MS Excel
I have a challenge presented to me. I have searched quite a bit, but I cannot find a solution that exactly works.
I have a drop down listing that represents the number of years (1-50). I need to ...
- 1
0
votes
0
answers
27
views
VLookup using Excel sheet to get data from another workbook
I have two Excel workbooks:
one.xlsx two.xlsx
'[one.xlsx]Sheet1'!A:A contains a list of 50 text strings.
Each string is the name of one of 50 worksheets in two.xlsx
where _NAME_ is one of those ...
0
votes
0
answers
14
views
vlookup data from another work book as per list of sheets name
I have 2 Excel workbook and the first contains one sheet with list of name.
This name is related to another excel workbook sheets name.
How can I use vlookup to get access to tablearray tese many ...
0
votes
1
answer
22
views
How can I write an excel formula to track trends based on strings and numeric position in moving rows on separate tables?
In this example which simplifies my data set, I have two tables representing months. I would like to be able to track the trend columns month on month.
In plain language the question is
If "cats&...
- 13
0
votes
0
answers
41
views
VLOOKUP formula based on 2 different values instead of 1
I need to fill in a cell with a value (account number) based on 2 different values (account name and department name) in 2 columns.
I have a table with account name in column A, Department number in ...
0
votes
2
answers
35
views
Comparing two columns across different sheets and returning a value from the 2nd sheet
my tables look somewhat like this:
Table 1
Name
Code
ABC
UH000511
CBS
BY044551
CLM
CZ004491
LBU
UA955100
Table 2
Company Name
Code
ABC Capital
UH000511
Central Bank of Scotland
BY044551
...
- 13
1
vote
0
answers
39
views
excel storing values that are being inputted daily
I have the following input in my excel, which somebody fills in manually every day. The date columns have the following formulas: =WORKDAY(TODAY(),-1) and =WORKDAY(TODAY(),-2)
At the beginning of ...
- 11
0
votes
1
answer
91
views
VLOOKUP Name Error even after using formula wizard
I'm having a really hard time trying to figure what is wrong in by VLOOKUP formula. I even used the formula wizard to try to fix it.
Here is the formula I'm using.
=VLOOKUP(A10,Melaminedetails,2,FALSE)...
- 1
1
vote
1
answer
49
views
Create hard-coded domains to autopopulate columns with aliases instead of codes in excel
I work with layer databases exported from ESRI ArcGIS Online. On ArcGIS, attribute tables have many columns (or fields) with codes. For each code corresponds a specific alias based on the properties ...
- 127
1
vote
2
answers
222
views
IF condition with partial match of an indexed VLOOKUP column - Excel
I have this sample of a spreadsheet to simplify what I'm trying to do:
In "Formula 1" I'm using a VLOOKUP function within an IF condition to assign value_if_true (and value_if_false) ...
- 127
0
votes
0
answers
30
views
How to return a cell reference value of a Parent ID?
I am trying to return the "parentid" from my dataset into my worksheet. I am using column E's value as my reference.
As you can see on the pasted copies for example. On Dataset worksheet ...
- 1
0
votes
0
answers
79
views
Copying values from one column based on the values in another column in Excel
I am trying to something that I feel should be simple VLOOKUP or XLOOKUP and have tried looking it up online with no success.
I have the following dataset:
Group
Code_Present
Code_Missing
Description
...
- 1
0
votes
0
answers
34
views
User with blank detail in output
As per the attached screenshot, I need a formula to derive user with a blank cell to be shown as pending. (Pending has been manually entered.)
- 1
0
votes
2
answers
11k
views
Vlookup with Blank cell
Vlookup with Blank cell
I have a Vlookup formula that I want to return "" if the value is empty.For example: =Vlookup(D2, sheet 1,A2:D2,3,0)
- 13
-1
votes
1
answer
332
views
Compare two sheets and show a summary with only rows where a specific column has changed for that primary key, without altering source data
I'm trying to generate a report that will regularly compare current raw data with that of previous reporting period and only show rows (primary keys) where a certain column's value has changed between ...
- 113
2
votes
1
answer
925
views
How to create dynamic sheet references with cell text in Excel
I am working with a large workbook and I want to drag formulas across to reference the title of their column with the corresponding sheet of the same name.
In this example: =VLOOKUP($B3,'04.22 NE'!$B$...
- 21
0
votes
1
answer
48
views
Finding aggregate return for multiple entries under same name
I would like to find the aggregate return in an excel for trading entries.
I have 3 columns, A - name, B - Buy, C - Sell.
For instance Sally first entry is Buy 2 and then later on Buy 3, and her last ...
- 101
-3
votes
1
answer
36
views
Joining tables with one key and multiple repeating values of the key on the other [closed]
I'm struggling to combine two sheets using the column of one as a key, and XLOOKUP is no help since the second sheet has multiple rows that match each of the key rows in the first.
Sheet A has 65 ...
- 1
0
votes
1
answer
100
views
Function to search for specific number and then to further search for the suffix
I have a huge amount of data to process in which 4 points with a related prefix needs to be subtracted from each other.
Example on the picture attached.
(let's call prefix a "ring number" ...
0
votes
1
answer
70
views
Xlookup or vlookup
Hoping someone can help me out with some excel magic -
I have two sheets.
Sheet 1 has a list of names in column D
Sheet 2 has a list of names in column B and corresponding ID's in column A
I need to ...
- 281
0
votes
1
answer
739
views
Excel column: If cell value is 0 replace with value from cell to the left
I am an excel novice. I have started working with data strings of over 1000 rows. Some cells in a column have 0 values and must be replaced with the value of the cell to the left. Currently, I copy ...
- 1
0
votes
2
answers
33
views
How to get adjacent cells of 3 smallest numbers in order?
I need 3 smallest numbers and corresponding cells. As you see first two 2s are A and the last one is O, but the output gives me A anyways. I would like to get them from the top to the bottom, so my ...
0
votes
1
answer
194
views
How to return adjacent cell value of the lowest cell
I'm trying to use VLOOKUP formula from this site but it doesn't work for me for some reason. It shows #N/A. How could I solve it?
0
votes
0
answers
69
views
VLOOKUP and Sheet Name using MID formula
I have a work sheet where VLOOKUP working properly but not work when i add a cell value that contain sheet name using formula
=MID(CELL("filename",A1),FIND("]",CELL("filename&...
0
votes
2
answers
67
views
Searching by Clicking a Cell
is there a function or some way to have excel return a result by clicking on a cell?
for example, if I have a list of groceries going down column B2:B10 and the isle they are located in going down C2:...
0
votes
2
answers
80
views
Return Closest Known Coordinate When Entering a New Coordinate - Excel
I have a sheet of known coordinates laid out as Col A - Point Number, Col B - X Value, Col C - Y Value, Col D - Z Value; see below image (a lot more rows in reality).
I am looking for a way of ...
- 1
0
votes
0
answers
58
views
In excel, how do I return values beside a searched string
I am currently trying to lookup a string value in a range and have it return the value from the cell above or below it. I have tried many formulas to no avail.=INDEX(B2:J49,MATCH($V$1,B2:J49,0)-1,1) ...
0
votes
1
answer
48
views
Finding the location of the most recent occurrence of a string across multiple columns
I have a table that looks like this:
p1 name
p2 Name
p3 Name
p 4 name
p1 Pre-Game ELO
p2 Pre-Game ELO
p3 Pre-Game ELO
p4 Pre-Game ELO
p1 Post-Game ELO
p2 Post-Game ELO
p3 Post-Game ELO
p4 Post-Game ...
0
votes
1
answer
57
views
Fill a cell with text & find match of a reference cell from previous entries, then automatically fill the respective "semi-adjacent" cells with a word
I am doing a daily task list excel sheet containing columns titled Month, Day, Task, Status, and Update. Cells under Status have a dropdown list choice of either "done" or "missed",...
0
votes
1
answer
110
views
Reference values in Excel Tables with a semantic reference?
Problem
I have an Excel Table Object:
In which I store assumptions for a formula.
Are there best practices for referencing a value in that table with a semantic reference?
Deeper Explanation
Attempt #...
- 101
0
votes
0
answers
296
views
How to use dynamic URL for VLOOKUP
In Excel, VLOOKUP can be used to look up data in a workbook on a remote server over HTTP, for example:
=VLOOKUP(A1, 'https://example.com/[data.xlsx]Sheet1'!$A$1:$B$999, 2, TRUE)
How can the URL ...
- 200
0
votes
1
answer
309
views
Excel VLOOKUP or INDEX MATCH with Multiple Criteria and Date Range
I have been struggling to solve this for a couple of days.
I tried some VLOOKUP or INDEX MATCH with multiple criteria but it doesn't work.
=VLOOKUP(TABLE 2B2&C2,TABLE 1 B:D,3,TRUE)
I have table 1, ...
- 3
0
votes
2
answers
38
views
Lookup a specific rowvalue when the column depends on another cell (row/column combination)
I have an excel sheet with a very large, scarcely populated matrix.
The first column describes an item, and the columns after that whether an item belongs to a certain group. Each item can only belong ...
- 101
1
vote
4
answers
136
views
Excel VLOOKUP multiple columns
I want to pull through 6 columns of information from 1 sheet to another sheet on excel when I type a customer name. I've tried multiple different array and vlookup formulas and nothing is working for ...
0
votes
0
answers
47
views
Count number of inquiries received on a given day for a given company where company name may have multiple spellings
I have an export of the 1000 customer inquiries for a given month for multiple companies on worksheet data.
B1 through AF1 has numbers 1 through 31 for each day of the month. A2 has our first company ...
0
votes
0
answers
48
views
How to avoid using VLOOKUP?
I have a workbook where the user can create a report then move it to a new workbook. This one takes up less than 1MB of space, and works well on my own Desktop.
In this report there are approximately ...
0
votes
3
answers
782
views
LOOKUP Column Value based on right-most value
I have a list of footage for a film that is continually changing. They are organized in rows by REELS, and the rightmost value will be the latest version. The first row are dates and the rest are ...
1
vote
1
answer
34
views
Vlookup search Bug
When I use VLookup to auto fill rows from a chart, it works for every search value except searches where the lookup value is CPT-X. In this scenario original formula:
If I change the lookup value to &...
- 11
1
vote
1
answer
161
views
VLOOKUP logic when range_lookup is TRUE but table_array is not sorted
Excel's VLOOKUP hint tells us to use range_lookup = TRUE only when the table_array is sorted. However, does anyone know what is the logic that VLOOKUP executes when range_lookup = TRUE but table_array ...
- 111
0
votes
1
answer
159
views
Lookup the 1st or nth appearance of value between two dates
In the example, column C is used to track the fast food consumed. The goal is to set up cell H2 to find the 1st fast food consumed between the dates in cell F1 and F2. H3 will be used to find the ...
- 13
0
votes
1
answer
71
views
HOW TO SUBTRACT LAST ENTERANCE WITH PREVIOUS ONE
I need help, I have been trying for hours to figure this out.
I need to keep track of material consumption and report it weekly so I need to subtract previous value of some material from current one.
...
0
votes
1
answer
192
views
Excel: How do I compare 4 columns with repetitions?
I have 4 columns. A,B,X,Y.
How do I compare all 4?
I want to create column Z where if A == X and the corresponding value B == Y, the result is 1. It is zero otherwise, how do I do that? Thanks
A
B
X
...
- 3
0
votes
0
answers
142
views
Matching values from 2 different excel and paste the column from excel 2 to excel 1
I have 2 different excel. Excel 1 is with all the company name with their branch company names and sales person names. Every sales person has different excels by their name. I have to take the sales ...
