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
1answer
31 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
49 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
28 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
62 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
29 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
126 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
37 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
22 views

Please help me with lookup formula

I have a task where there are 2 sheets: Sheet 1 has 5 columns Sheet 2 has 2 columns I have to compare column 4(DOJ) of 1st sheet with column 1 (DOJ)of 2nd sheet and so that I get the value of ...
0
votes
0answers
21 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
29 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
34 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
50 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
24 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
61 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
17 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
54 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 ...
0
votes
1answer
32 views

How to search in a row and populate Yes/No value in another row - excel

I have two columns A and B. Column A has rental property descriptions. I want to search each row containing the word "parking" and return Yes/No in column B I tried using =IF(SEARCH("parking",A2),"...
0
votes
1answer
24 views

Extracting data from a column using look up

I am trying to get the formula that extracts the membership numbers from any cancellations from column F into column U Cancellations show in column O as 14DMB. I have inputted the data manually and ...
1
vote
2answers
72 views

VLOOKUP formula with dynamic address (second parameter), depending on current cell

I need a VLOOKUP that doesn't search the entire range of the column, but from an address that changes depending on the current cell. company1 user1 01/2020 fixed val2 1200,00 fixed ...
0
votes
3answers
41 views

Vlookup is not working fails with N/A return despite i have value

My Vlookup function isn't working, it fails with N/A despite the fact that I have values. Have a look in screenshots how can i solve it See File
0
votes
0answers
58 views

Excel - How to vlookup to return multiple & repeated values?

I am trying to vlookup value & return multiple values into 1 cell (including repeated values). Something like below: I've found a solution from other page with the codes below, unfortunately the ...
0
votes
1answer
57 views

Excel - Look up on multiple tables - complex

I am trying to make it so that my operators can cut and paste information into an Excel spreadsheet, and then I will have a Vlookup, etc. to be able to get the information I need. The problem is that ...
0
votes
0answers
20 views

Excel - Need to get info from multiple resizing tables - Match, Indirect, VLookup

I am trying to make it so that my operators can cut and paste information into a spreadsheet and then I will have a Vlookup, etc. to be able to get the information I need. The problem is that I have ...
-1
votes
1answer
56 views

What Excel formula to use?

I ONLY have 2 column which is the "date" and "number". I really don't know how to explain it but for example in the date column, i have "12/20/2019" with corresponding number of "123". I want to ...
2
votes
1answer
130 views

How do I join 2 tables in LibreOffice Calc?

I looked up one of the other answers here but it's not helping me. I have 2 sheets and I'm trying to join 2 columns from my Sheet2 to my Sheet1 by joining on a common column- Sheet1- Sheet2- When ...
1
vote
0answers
7 views

how I find a value within a cell (LLC) in one spreadsheet and then if found copy that row of data into another spreadsheet

I have a spreadsheet with lots of data. In the "owner " column some owners use the letters LLC after their name. I want to find any rows that have the letters LLC in them and either filter in place or ...
1
vote
0answers
20 views

Autopopulate a full table

Is there any way of autopopulating a full table in excel eg, when a heading is listed it will bring up a table from another sheet based on the heading? To explain a bit better, I work in a lab and I'...
0
votes
2answers
45 views

Excel Input letters to value

I want to assign fixed values to input letters. I'm able to do that with VLOOKUP, but the case is that I need this for 100s of records. For example, I have given values to: S=50 U=60 P=70 E=140 R=24 ...
1
vote
1answer
120 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
2answers
83 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 | ...
1
vote
0answers
24 views

How to search for and return all records between two dates?

I'm not sure if this is a lookup formula I need. Basically, I have a huge spreadsheet with the travel details of lots and lots of groups. Each row is a different group. For reference, Column K shows ...
0
votes
1answer
46 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
1answer
154 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
0answers
54 views

How do I dynamically update vlookup table when another lookup value is added?

I have a simple (formatted as) table (Table 1), ranked based on Rating. Rank Name Rating 1 etc etc etc 4 etc etc etc 3 etc etc etc 2 etc etc etc I have a VLOOKUP (formatted as) table (Table 2) ...
0
votes
2answers
33 views

Fill up according to correlation

I have the following two worksheets. Worksheet1 (ws1) with the correlation between numbers. A B 0 5 1 7 2 8 3 12 4 16 And worksheet2 (ws2) with the gaps that need to be filled in. A B ...
0
votes
1answer
34 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
votes
1answer
60 views

How to Use Vlookup with IF Statement in Excel?

Now, let's assume, I have decided on the condition that if the scores scored by an XYZ student are higher than 90, then it will be shown as "Great," otherwise it will be shown as "Good." Now, when I ...
0
votes
1answer
466 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
1answer
35 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
0answers
85 views

Excel INDEX/MATCH function difficulty with CSE

I have an INDEX/MATCH function in one of my formulas to look up and match information with multiple criteria. I know that the first time the formula is entered, it is required to use ctrl+shft+entr (...
3
votes
2answers
797 views

Return list of all values that match Two criteria

I am trying to setup a formula that returns values that satisfy two criteria. E.g. A B C 1 Bob Banana 10 2 John Banana 10 3 Steven Apple 5 4 Elliott Apple 2 ...
0
votes
0answers
33 views

MS Excel - how to prevent vlookups from breaking?

I've created a template that consists of tabs that I vlookup data from. I need to be able to rename the new version of the file without the vlookups breaking. How do I do this? Also, any tips when ...
0
votes
2answers
68 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
1answer
130 views

Excel How to combine all rows having the same id number into one column for a huge dataset?

I have a 350K of rows in an excel file. I need to combine all rows having a unique id to the same row as following: Unique ID | Mbr ID | Name 1 | 10227 | ABC1 1 ...
0
votes
1answer
25 views

Nesting VLOOKUPs if the result is #N/A

I'm doing a VLOOKUP but some of the values can't be found in my range and returns #N/A. To be expected but if that happens I want to do another VLOOKUP to another range. I can't figure out how to ...
0
votes
1answer
77 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
0answers
45 views

Getting garbage values with VLookUp

I am trying to simply use a vlookup command I am not able to detect any errors with my data. please take a look at screenshot below: My problem is value e2 does not exist in range "final" and yet I ...
0
votes
1answer
18 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 ...
0
votes
0answers
18 views

Auto Hide in Excel

I have an Excel Table with some data in it. I have used a slicer to list by entry name. I would like to temporarily hide the empty columns per filter. I have tried a set of VBA scripts but they all ...

1
2 3 4 5
8