# 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.

397
questions

**0**

votes

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**3**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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 ...