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
2
votes
1answer
38 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 ...
1
vote
1answer
25 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 ...
0
votes
2answers
48 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, ...
2
votes
0answers
28 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 ...
0
votes
1answer
23 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/...
0
votes
0answers
15 views

Vlookup for duplicate

Good day, I want to create a VLOOKUP formula on a summary page that will return a total amount for each reference number in one cell. An example as below: Employee Code CTC Gross 04532 996.52 ...
0
votes
3answers
47 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 ...
0
votes
0answers
42 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.
1
vote
1answer
67 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 ...
1
vote
0answers
8 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 ...
0
votes
1answer
45 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 ...
0
votes
2answers
27 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 ...
0
votes
2answers
41 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 ...
0
votes
0answers
10 views

VLookup won't work between different tabs or workbooks on any system

On my new work laptop VLookup will not work when I try to lookup between two tabs or two different work books. It get to the second element of the VLookup (the comparison data) and it doesn't ...
0
votes
0answers
30 views

VLOOKUP having one consistent name from multiple data sources in Excel

I am trying to import data from multiple different websites and trying to organize values and corresponding names into one clear table. For example when I import data from one website the persons name ...
0
votes
1answer
25 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, ...
0
votes
1answer
32 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 ...
1
vote
3answers
112 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) =...
0
votes
1answer
73 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 ...
0
votes
2answers
41 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 ...
-1
votes
1answer
59 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 ...
1
vote
1answer
34 views

Excel - Concatenating cells returned through looking up against duplicate values

I have a unique problem that I have been unable to solve and hoping to get insights from the experts here. I have the below table: Sprint ID# Description 1 ABC 1 XYZ 2 ...
0
votes
3answers
222 views

Is there an option or setting that prevents VLOOKUP from returning zero when it finds blank cells

Is there an option or setting that prevents VLOOKUP from returning zero when it finds blank cells or does not find the lookup value. I do not want to suppress the zeros by formating them out. I want ...
0
votes
1answer
387 views

Increment the cell in Vlookup when dragging horizontally in Excel

I have a Vlookup formula in excel =VLOOKUP($A2, Kenya!$A$2:$L$34,2,FALSE) I'm trying to drag this formula in columns (to right side of the sheet) and I want the the row of the lookup value to ...
7
votes
1answer
657 views

VLOOKUP returns values for some Lookup values but not others

I'm not sure why VLOOKUP isn't returning the value. I have confirmed that I'm using the VLOOKUP correctly and that both values 1 and 2 are a match (no leading/trailing values, etc). Does anyone know ...
0
votes
3answers
383 views

EXCEL: Number of days since last visit

I am trying to calculate the number of days since a specific person last visited a location. Looking at the following sample dataset, what would be the best method? I tried making an index column and ...
0
votes
2answers
51 views

EXCEL; I would like to match two email address from two different worksheets and return a value of 2 cells (phone numbers)

i have two work sheets one contains ALL the information and one is a filtered version with some additional info add, i would like to match an email addresses (column Q)sheet 1 to (column D) sheet 2 ...
0
votes
0answers
70 views

Vlookup Not working on duplicate Values

i m using excel 2010 and i have questioned about vlookup. I have two excel sheets and one contain duplicate records (Product Name). in other sheet contain the product Code along with the Product name. ...
0
votes
3answers
83 views

Excel formula help multiple criteria drop down

Hi, I am hoping for some help in a V look up when using two drop downs for todays date (G1 & G2). The table on the right are calls made each day will contain data of calls made by employees, it ...
0
votes
0answers
9 views

excel vlook up and match function

i have a payment receipt excel sheet. i make bill with unique bill number and as and when party make payment i make receipt against the specified bill. and for that i have system working with Vlookup ...
1
vote
2answers
128 views

Unsure if vlookup, hlookup or index match needs to be made to fill out values in a X,Y,Z mesh

I would like some help with an an Excel formula as I am unable to infer if I need to use hlookup, lookup or index match for this. I have 3 columns of data but how can I create a X, Y, Z mesh. How can ...
0
votes
1answer
132 views

Copy Paste Special Value - Vlookup Edition

I am an accountant dealing with lots of financial statements. I typically use a vlookup to pull in numbers from another spreadsheet into my template containing the desired format. The best solution ...
0
votes
2answers
57 views

VLOOKUP MATCH Formula

I have a worksheet of data (sheet 1) with around 1000 reference numbers (reference numbers ex dea564ee45bf47ddb156806528eeb4d5). On another sheet (sheet 2) I have a shorter ~20 list of reference ...
0
votes
1answer
33 views

VLOOKUP if Client ID is customer during the same month during different years

I have a list containing four columns: Client ID, Year, Month, Recurring customer. Each transaction during a month creates a row. I want to see if the same Client ID has a transaction on the same ...
0
votes
1answer
32 views

Need help getting excel to pull values from a chart using name and date

I have an excel sheet that reps daily numbers into. I am trying to create a second chart that can show the daily totals based on the date entered into a selection cell. Attached a picture for a ...
0
votes
1answer
68 views

Inputting several values, found from a VLOOKUP function, into a COUNTIF function

This question is about a single function (in a single cell to later extrapolate over a whole table) in Microsoft Excel. I want to find a unique id on another page (amongst other id's in the first ...
0
votes
1answer
36 views

How to solve a #N/A or #VALUE! that should not occur as a result of a VLOOKUP in excel 2016 since the searched value exists?

I have several VLOOKUP that returns #N/A or #VALUE! even when the searched value is in the lookup range. For many lines, they return the expected value. For example: =VLOOKUP(A26;'TAB2'!$AA$2:$AI$...
1
vote
1answer
63 views

Excel lookup by minimum value

I have this table: . Is it possible to look up the letter grade by the minimum percent value? For example, anything greater than or equal to 87% but less than 90% returns B+.
0
votes
1answer
54 views

How to vlookup a value when the lookup_value is linked to another tab?

I have an excel spreadsheet with three tabs. In the first tab, i have a column with 4 different employee ID. On second tab, n the first column, I have different employee ID numbers including some ...
0
votes
2answers
132 views

How to use INDIRECT in Excel for quoting sheet name?

For example, I have sheets Level 3 Grade G Level 4 Grade F Level 5 Grade E Level 6 Grade D Level 7 Grade C Level 8 Grade B I wish to use cell F2 for the these names and make references. For example, ...
1
vote
1answer
43 views

Excel - lookup by multiple criteria

Based on the attached screenshot, I have a sample database on the right side. I would like to input random models, capacity, and grade on the right side, and receive an output of pricing. How would I ...
0
votes
0answers
23 views

Can I make Excel add cells together if they fall between dates and match another criteria?

I'm trying to count the number of widgets sold across a number of different shops on a street, within a certain time frame. If I could get a VLOOKUP to work, it would look something like this: =...
1
vote
1answer
41 views

Excel - How do I look up multiple cells from a single reference?

I'm looking to somehow look up a certain amount of cells from a single reference and return them in the same order in another workbook. For example, say I have 5 different SKU codes (these aren't ...
-1
votes
1answer
39 views

Can I change the default match method in Excel from “Less than” to “Exact match”?

By default, MS-Excel uses 1 - Less than as match method in functions like vlookup and match. Apparently Excel assumes the data is sorted and if the value I am looking for is missing, the value just ...
0
votes
2answers
64 views

Excel Matching on Multiple Criteria including dynamic ranges based on certain criteria

I am trying to find the optimal formula for the following. I need to pull in a value(Percent_Number_I_Want) based on 3 criteria: the first two are Group_Lookup and Name_Lookup. The third condition ...
0
votes
1answer
25 views

Need to Vlookup a specific phrase in a cell, and then go find another value in another table

Thanks for the assistance in advance! I've got a table filled with campaign data. I need to write a function to look at a column "IO number" in Sheet 2, Column A, in this example "AM262" and then go ...
0
votes
2answers
147 views

SumProduct Multiple columns using name for column index Vlookup across multiple sheets

I am trying to sum multiple columns from a table on a separate sheet using vlookup and matching the column index number with a name instead of the column number. I can return a single result but can ...
0
votes
0answers
32 views

Find where a mileage range falls within a list of setranges

This is my first post and not sure on the various etiquettes so apologies in advance if I have done it wrong! I have a list of mileage ranges I'm going to call '8ths'. For example, one range is 004....
1
vote
0answers
40 views

Using Excel, how can I automate incoming weekly reports/audits to pull data and insert into a new report?

I'm trying to figure out where to start with this so I appreciate any suggestions on something I can do some further research on. My work relies heavily on reports & audits weekly (sometimes ...
1
vote
1answer
430 views

Subtract a Vlookup value from another cells value only if a cell has a value

I am attempting to automate a spreadsheet and subtract a vlookup value from another cells value only if that cell has a value. Both values are times (hh:mm:ss) where Q3 will always be larger than the ...

1
2 3 4 5
9