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

**2**

**1**answer

### Excel: Get sheet name from Drop down Cell for formula

**1**

**1**answer

### Excel Lookup from different sheet

**0**

**2**answers

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

**2**

**0**answers

### VBA vlookup for multiple columns

**0**

**1**answer

### Combining an Excel IF Statement with VLOOKUP

**0**

**0**answers

### Vlookup for duplicate

**0**

**3**answers

### Excel VLOOKUP for range of dates

**0**

**0**answers

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

**1**

**1**answer

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

**1**

**0**answers

### Variable within worksheet name

**0**

**1**answer

### How to do VLOOKUP over every sheet in Excel?

**0**

**2**answers

### Return value based on date

**0**

**2**answers

### “Advanced” VLOOKUP range

**0**

**0**answers

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

**0**

**0**answers

### VLOOKUP having one consistent name from multiple data sources in Excel

**0**

**1**answer

### Sorting and ordering two expense lists by a third list of categories using Excel 2016

**0**

**1**answer

### VLOOKUP Syntax for Conditional Formatting Rule

**1**

**3**answers

### How to specify the search column with VLOOKUP?

**0**

**1**answer

### Copying cell colors to another sheet

**0**

**2**answers

### return yes or no based on cell data from another sheet

**-1**

**1**answer

### How to combine table 2 sheets (ข้อมูลตัวอย่าง1 and ข้อมูลตัวอย่าง2) to new table 1 sheet (Use VLOOKUP formula with multiple condition)?

**1**

**1**answer

### Excel - Concatenating cells returned through looking up against duplicate values

**0**

**3**answers

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

**0**

**1**answer

### Increment the cell in Vlookup when dragging horizontally in Excel

**7**

**1**answer

### VLOOKUP returns values for some Lookup values but not others

**0**

**3**answers

### EXCEL: Number of days since last visit

**0**

**2**answers

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

**0**

**0**answers

### Vlookup Not working on duplicate Values

**0**

**3**answers

### Excel formula help multiple criteria drop down

**0**

**0**answers

### excel vlook up and match function

**1**

**2**answers

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

**0**

**1**answer

### Copy Paste Special Value - Vlookup Edition

**0**

**2**answers

### VLOOKUP MATCH Formula

**0**

**1**answer

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

**0**

**1**answer

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

**0**

**1**answer

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

**0**

**1**answer

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

**1**

**1**answer

### Excel lookup by minimum value

**0**

**1**answer

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

**0**

**2**answers

### How to use INDIRECT in Excel for quoting sheet name?

**1**

**1**answer

### Excel - lookup by multiple criteria

**0**

**0**answers

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

**1**

**1**answer

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

**-1**

**1**answer

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

**0**

**2**answers

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

**0**

**1**answer

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

**0**

**2**answers

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

**0**

**0**answers

### Find where a mileage range falls within a list of setranges

**1**

**0**answers

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

**1**

**1**answer