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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
10 views

How do I work on vlookup for percentage columns

I am working on pivot table created from the big datasheet. So in the pivot table there is YoY calculation. I want to group the percentage using vlookup to create a group has 4 different categories. ...
user avatar
0 votes
0 answers
43 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 ...
user avatar
0 votes
3 answers
47 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 ...
user avatar
0 votes
0 answers
14 views

Getting values from a closed workbook with path referenced on open workbook

I want to get data from different closed workbooks, right now I am using this formula: =VLOOKUP("*"&DB!$B30&"*";'https://company.sharepoint.com/sites/Analysis/Study/[file1....
user avatar
  • 1
1 vote
1 answer
17 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 &...
user avatar
  • 11
0 votes
1 answer
38 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 ...
user avatar
0 votes
1 answer
39 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. ...
user avatar
0 votes
1 answer
25 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 ...
user avatar
  • 3
0 votes
0 answers
15 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 ...
user avatar
1 vote
0 answers
49 views

Why are my Excel formulas not working as expected? [closed]

These are practice questions from a textbook. I'm trying to solve these questions using MS Excel. Attached are screenshots of the questions with examples I have tried below: For total revenue, I used ...
user avatar
1 vote
0 answers
35 views

how to perform VLOOKUP on two separate excel files

I have two separate excel files. I want to copy the value of column code from file 1 and paste it to a new column (lets say code) in file 2 where the value of column ID of file 1 is equal to that of ...
user avatar
0 votes
1 answer
52 views

Macro to check date range against criteria

I need VBA code to check each weekday date in a date range against a table in another sheet, if the corresponding value is >9% for any of the days, it should return a msg box i.e, in the "...
user avatar
0 votes
2 answers
35 views

Excel wildcards not finding the matches they should in VLOOKUP function

I have multiple product families I'm working with, and each family has multiple products within. Some families have more products than others, all product names are unique. On one sheet named "...
user avatar
0 votes
1 answer
52 views

VLOOKUP and HLOOKUP combo

I am struggling with the following (see snapshot) and I can't understand what I'm missing. If the id matches, I would like to extract the value of that id in when the values in col2 matches the ...
user avatar
  • 101
0 votes
0 answers
59 views

Vlookup formula isn't subtracting for certain cells and not others

My Vlookup formula isn't subtracting the info it pulls from my pivot table and I can't figure out why. I've run tests in other sheets and get the same results (works with some data but not others). I'...
user avatar
0 votes
2 answers
40 views

Find last 2 values & calculate % change

I need to calculate the percent change for the last 2 cells (months). The last 2 cells change monthly, with new data added. I need the formula to find the last 2 cells--with value--in the row, and ...
user avatar
0 votes
0 answers
29 views

Excel data comparison query - Vlookup or IF statement

I have two sheets to compare in excel. I have to see if a student has passed different exams. One sheet1 I have a list of the student refs in column A (A2-A10) and the exam refs in Row1 (B1-E1). In ...
user avatar
0 votes
2 answers
32 views

VLOOKUP Values not corresponding

I have an excel file that contains Olympic Data for 2008, 2012 & 2016. I would like to lookup the event of my dataset in sheet 1 to the table array in VLOOKUP sheet to determine whether the event ...
user avatar
0 votes
2 answers
104 views

From an Excel list of event attendees spanning 10 years, how do I create another list that pulls the first year of attendance for all my attendees?

I have a list of guests that come to my events. The list contains 10 years worth of guest check-ins in order by date (ascending). Based on this list, I want to create another list that shows the year ...
user avatar
  • 1
0 votes
1 answer
44 views

Get VLOOKUP "lookup_value" to refer to a cell reference?

I have this table in the top-left of my sheet: I want to point VLOOKUP to cell A2 above, so that it returns 2. How can I achieve this? This doesn't work: // this outputs 1, not 2. =VLOOKUP(A2,A1:B3,2,...
user avatar
  • 179
0 votes
1 answer
490 views

VLOOKUP won't work unless text is retyped manually even after cleaning and trimming

I have been having this problem with the VLOOKUP function lately. I have two arrays with mostly the same data in the first column and I'm trying to stitch them together using VLOOKUP as I've always ...
user avatar
-1 votes
1 answer
38 views

Lookup Value With No Blank Cells

I need help with finding the proper code for looking up a value. From the screenshot, I would like to lookup "Brown" from Panel 1 but I continue to get blank spaces in between like Panel 2. ...
user avatar
  • 3
0 votes
1 answer
126 views

File name on the basis of cell value in vlookup

Currently, I am using vlookup as per the below: This is in Cell M3 of main book: =VLOOKUP(L3,'C:\Users\vp\Desktop\xcl\day_data\[5460993.csv]5460993'!$A:$C,3,0) The value in Cell Z3 of the main book ...
user avatar
  • 11
0 votes
1 answer
36 views

How can I compare column values from two different work sheets?

I have two different Worksheets (A and B), both of which contains the columns PackageName and PackageVersion, both Column B and Column C respectively in each worksheet. I would like to have a third ...
user avatar
0 votes
2 answers
62 views

Excel multi layer if vlookup and formula

I've produced a simplified document that shows the essence of what I'm trying to achieve. The image of the document: There are 5 shops that all stock Apples, Pears, Bananas, and Oranges. Internally ...
user avatar
  • 1
0 votes
1 answer
103 views

Excel, Apple. How do auto fill one cell with corresponding info based on entry of another cell?

I have three sheets. Sheet 1(Model Number) Sheet 2(Item Number) Sheet 3(Reference). I want to be able to put a model number of an item in to a certain cell (J17) on sheet 1 and have it auto fill the ...
user avatar
  • 1
0 votes
2 answers
53 views

How do I update Excel's vlookup formula for multiple workbooks?

I have thousands of Excel files with vlookup formula. How do I update the formula in all files at once? The files were moved and and I need it to be looking up in a new path.
user avatar
  • 13
0 votes
1 answer
29 views

Excel transforming columns based on multiple cells data

I am very new to excel and was trying to transform my data. I have the following data And would like to transform it to Here if any "column" value corresponding to the "ID" is &...
user avatar
0 votes
1 answer
41 views

Auto-populate data

Tricky problem for me. Is it possible to use a drop-down box (or alternate tool) to select a specific week, then use this to auto-populate data into a larger data table? E.g. step 1 - select week e.g. ...
user avatar
  • 1
0 votes
2 answers
44 views

Return Specified Values From Another Sheet

I have two Excel sheets open. The first sheet has data organized by Student ID and by School (two different column). In the second Excel sheet, I simply want to return a column that shows the Student ...
user avatar
0 votes
2 answers
290 views

Display multiple row with data according to ID value

I want to ask as well about this. For example: One ID has multiple rows with value (one row is equal to one dependent). So ID:001 Has 4 rows (4 dependents) 001 | Marie | 03/23 | Female 001 | Raffy | ...
user avatar
0 votes
2 answers
69 views

how to change the formula needed without changing the other formula? vlookup

How can I increment the column reference in a VLOOKUP, so that when i drag the formula left it increase's by 1 each time, without me having to do this manually. =VLOOKUP($A3,'Lazada qty 1-19 June'!$A:$...
user avatar
2 votes
1 answer
231 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 ...
user avatar
1 vote
1 answer
31 views

Excel Lookup from different sheet

i have sheet in below formats Sheet1 Sheet2 Now i have to validate my Sheet1 as per Sheet 2 if ID exist and country present its "Match" else "No Match" if no entry then "No ...
user avatar
  • 95
0 votes
2 answers
115 views

If VLookup Function that add corresponding cells if 1 range matches another

If B4 matches a # in column A I need the formula to return the # in column C and then add... For example: Since B4 matches A1, I need C1 (90) +E1 (3) + F4 (0) and return the value in C4. I tried this, ...
user avatar
1 vote
0 answers
89 views

VBA vlookup for multiple columns

I am trying to compare two tables of data on the same sheets and display matches in a 3rd table. I can get the first column in the 3rd table to return matches however the other matches don't display ...
user avatar
0 votes
1 answer
31 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/...
user avatar
0 votes
3 answers
57 views

Excel VLOOKUP for range of dates

I have been struggling with VLOOKUP for sometime. I want to use VLOOKUP for a range of dates using the two tables I have given. I want to get which Term each row belongs to. Basically I want to check ...
user avatar
0 votes
0 answers
94 views

VLOOKUP only returns the first column of the columns that I specify

I'm asking VLOOKUP to return the 2nd, 3rd, and 4th columns in a match. It only returns the 2nd column.
user avatar
1 vote
1 answer
114 views

How do I count multiple levels of referrals (A referred B, B referred C, D & E, E referred F, G, H, I, etc)?

I have a referral system where you get credit for referring other customers. If those customers refer other customers they get some level of credit for those as well. We need to count not only how ...
user avatar
  • 99
1 vote
0 answers
12 views

Variable within worksheet name

I have a VLOOKUP that looks like this. =VLOOKUP("MISC",'[lastname^J Firstname.xlsx]Lastname, Firstname 2021'!$A$15:$M$21,2,FALSE) How can I make the "2021" in the sheetname a ...
user avatar
0 votes
1 answer
49 views

How to do VLOOKUP over every sheet in Excel?

I have Excel file, which will have many sheets (and I do not know their names right now - they will not follow any specific directive, they will represent dates of orders). I have a column that ...
user avatar
0 votes
2 answers
33 views

Return value based on date

I am running into an issue where I have various sectors that have been scored differently depending on the year. See example below: 2017 2018 2019 2020 ...
user avatar
0 votes
2 answers
48 views

"Advanced" VLOOKUP range

I am having some problems with the problem as stated: I have a worksheet containing column A with different well names. In a second and third column, there are top and bottom depths of a geological ...
user avatar
0 votes
1 answer
29 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, ...
user avatar
  • 147
0 votes
1 answer
48 views

VLOOKUP Syntax for Conditional Formatting Rule

I'm writing a conditional formatting rule that formats a cell if a VLOOKUP formula returns a value > 0. I usually write out the formula in a cell first to ensure it is syntactically correct. In ...
user avatar
  • 103
1 vote
3 answers
440 views

How to specify the search column with VLOOKUP?

With this table: 1 a aaa 2 3 bbb 4 d ddd 3 c ccc I'd like to search a value in the first column, and get the second column value. Of course, this works: =VLOOKUP(1; A1:B4; 2) =...
user avatar
  • 1,636
0 votes
1 answer
84 views

Copying cell colors to another sheet

My active sheet (let's call it Sheet1) will be main for all users to edit and view. User 1 only needs to view half the data in Sheet1 at a time so I've created a Sheet2 to only display the data that ...
user avatar
0 votes
2 answers
561 views

return yes or no based on cell data from another sheet

I have two sheets. The first sheet "Example A" and the second sheet "Example B". Example A has a master sheet of clients that may also be on Example B. If the client is listed on ...
user avatar
-1 votes
1 answer
61 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 ...
user avatar

1
2 3 4 5
9