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

**0**

votes

**0**answers

13 views

### VLOOKUP equivalent for ms-word: help to auto-populate cells in a table

I would like to be able to enter information in the first cell of a row, and for Word to auto-populate the other cells in that row with pre-determined data.
At present, the cells in the first column ...

**1**

vote

**2**answers

115 views

### Excel Formula CONTAINS

I need a formula that will look for a specific text in a cell that is also referenced on another sheet and input the value next to it. Kind of like a vlookup but with an if statement. "if text ...

**-1**

votes

**1**answer

19 views

### Excel, If two columns match on different workbooks, then paste another string column from the 2nd workbook to the 1st workbook

How do I tell Excel that if a string column with company names matches another string column with company names from another workbook, then print the Contact Name from the 2nd workbook to the 1st ...

**1**

vote

**0**answers

10 views

### Cannot lookup value and create conditional formatting in excel 2010

I have one worksheet which has in the A column product sku and at C D E columns supplier names.
Each supplier has its own worksheet which has again product sku price and availability.(suppliers ...

**0**

votes

**1**answer

39 views

### Using VLOOKUP with data in nonadjacent columns

I have my data stored in
and
I want to pull a subset of that data based on the selection in a dropdown. For example, if I select "Org 1" in the dropdown, then all the indicator data (Indicators 1-...

**0**

votes

**2**answers

36 views

### index and match for currency conversion

I am currently working on a billing report from multiple countries. The billings are set on particular country's currency. So I am trying to convert them to USD for the conversion rate of billing date....

**1**

vote

**3**answers

99 views

### Search a field based on two or more columns

I want to output the professor field based on the input in the yellow fields. The input will be the possible sub_code of column D OR column G. I've tried VLOOKUP(...) and INDEX(...,MATCH(...)), but I ...

**0**

votes

**2**answers

53 views

### Combining IF Functions or what works better

Trying to figure out how to show the value from a cell when doing IF.OR function.
Here is my function (not working):
=IF($P$14="";"";IF(OR($P14="PALLET";"$H14";"$L14"))
The function should show ...

**-1**

votes

**0**answers

18 views

### Vlookup For time range and duplicate removal

My data is like in the picture and like to display it like the sheet.
I tried the Formula:
=SUM(--(FREQUENCY(IF(MOD(Table2[A],1)>=D2,IF(MOD(Table2[A],1<D3,MATCH(Table2[BBB],Table2[BBB],0))),...

**1**

vote

**1**answer

43 views

### Compare excel worksheets

Here is the problem I have been trying to resolve all morning - I have two Excel worksheet files:
Subset: This file has a subset of employees with various details including training status such as in-...

**0**

votes

**1**answer

34 views

### Excel table conversion help needed

Here is the current table:
I would like it to look like this:
I have tried vlookup and it works okay, but I can't get the data per person without changing the array table per person. As you can see ...

**0**

votes

**1**answer

31 views

### How to return multiple values if a row contains a value

I want to look up a number in column A and return column B and C if it is there. So, on another worksheet I'd input FG30827110 and have four items returned (Each item in column B and C returned).

**0**

votes

**1**answer

37 views

### How to find and select multiple items / values at the same time in Excel

here is an over simplified example of my problem
I have 2 excel spreadsheets.
The first spreadsheet has 1 column with a list of names
John, James, Steve, Richard, Bob
The second spreadsheet also ...

**-1**

votes

**2**answers

55 views

### VLOOKUP for a range of letters [closed]

I need to take a range of letters for example:
if the cell contains A, B, C, or D and fill a cell with P1.
If the cell contains E, F, G, or H fill a cell with P2.
If the cell contains I, J, K,or L ...

**0**

votes

**1**answer

41 views

### How do I reference a value in one excel sheet that is in the same row as in another sheet.

I have two excel sheets, each has a column called unique ID. The first sheets has a value associated with that ID, the second has a description. How do I pull the description from sheet two into sheet ...

**0**

votes

**1**answer

43 views

### using IF AND VLOOKUP and dates together

I'm trying to use an IF AND function along with a vlookup to return prices from each supplier based on a given date
=IF(AND('Input Wheat'!$H$5:$H$1489=Summary!A7,'Input Wheat'!A5:A1207=Summary!C7,...

**0**

votes

**1**answer

32 views

### Lookup Value from two sheets by dates

I am trying to lookup ID values from two sheets which have dates ..I am trying to lookup value by date....Can you please help me ,,I have attached sample excel sheet and highlighted the sample below ...

**2**

votes

**1**answer

97 views

### Excel VLOOKUP function giving the incorrect value. Can somebody identify mistake?

I have been using the VLOOKUP function a lot in Microsoft Excel but these last two days have been rough. I have been trying to "match" the state population with the state name. I was able to use the ...

**-2**

votes

**1**answer

90 views

### MS Excel partial match sheet1!A1 with sheet2!A1 return sheet2!B1

I need to return values from Sheet2!B1 where the string in Sheet2!A1 partially matches the string in Sheet1!A1. I have 3000 rows of random letters and numbers in A1 with the corresponding logical ...

**0**

votes

**0**answers

31 views

### Vlookup Bucketing Issue with Percentages

Excel's Vlookup's functionality to bucket/categorize values has been quite helpful but I'm running into an issue when attempting to bucket %s (factional numbers). My formula below is outputting "...

**0**

votes

**1**answer

113 views

### Weird VLOOKUP issue in a macro heavy worksheet

I have quite a weird issue with a workbook I built that is very macro dependent. It centers around a simple VLOOKUP().
Currently my macro creates a line item on one sheet (Sheet A), then copies said ...

**0**

votes

**0**answers

25 views

### How do distinguish cells with text from blanks in vlookup?

I have a spreadsheet that list the company employee name and employee by code.
I capture raw data for everyone but I only want to display the data for specific code(s).
So, I have a vlookup to ...

**2**

votes

**1**answer

167 views

### VLOOKUP() to a Table on a different worksheet returning an #N/A error

I have 2 tables, daily entry
and summary
My formula in BQ20 of the summary table is currently:
=IF(VLOOKUP(BQ5,Table11[DATE],1,FALSE),VLOOKUP('SUMMARY (NEW)'!B20,'DAILY ENTRY'!A:H,8,FALSE),"")
...

**2**

votes

**1**answer

188 views

### Return and sum multiple values using a wildcard criteria

I'm trying to create a complex formula that does the following:
Looks up data in column A of another sheet using a "contains" criteria (xxxx&"*")
Returns all matching values from a specific ...

**1**

vote

**1**answer

72 views

### Excel - VLoolup with Match - Is This an Optimal Solution?

I'm trying to avoid the redundancy of calculating the same index as many times as there are records, so should I pre-calculate the index with MATCH in a hidden cell above my table?
It is also worth ...

**1**

vote

**1**answer

63 views

### Having trouble using VLOOKUP() with multiple worksheets and multiple inputs

I'm trying to set up a quick way to pull data based off two inputs.
The inputs are on the first worksheet, Journey. The first input, C2, is a dropdown list where the selections are the same as the ...

**2**

votes

**1**answer

33 views

### Lookup value in a row based on keyword

I'm trying to lookup a value in a row based on a keyword and return the value.
Example:
Column 1 Column 2 Column 3 Result
http://1stexample.com http://...

**0**

votes

**1**answer

90 views

### VLOOKUP with multiple criteria not working correctly

I am currently trying to run a VLOOKUP that has has multiple criteria. I am to use a MAX(IF()) function to get the maximum value based on a certain criteria. Here is my code:
IF(AND(SUM(COUNTIF(A7,{"...

**0**

votes

**1**answer

93 views

### Excel Match with reverse wildcards

this is my table:
A B c
1 foo.com/page1 foo.com/page1?xyz
2 foo.com/page2 foo.com/page1?abc
3 foo.com/page3 foo.com/page8?xyz
for each item in ...

**0**

votes

**1**answer

155 views

### Remove two or more words in a cell based on lookup value

I want to remove the words "FaKe TaBLet" in B2 into a new desired results like in C2, which is 'great number two' using (as far as I know) Reverse partial lookup or other formula instead of using '...

**0**

votes

**1**answer

177 views

### Need formula to calculate tiered commissions, according to percentages

First off, I have looked everywhere, and every solution assumes that I'm working with dollar amounts, but my client works with percentages. That being said, I need to figure out the formula to ...

**0**

votes

**2**answers

73 views

### Match values accross tabs in Excel

I have the following scenario:
I have a 1 tab with ~600 Event IDs and Event Names. Then I have another tab with ~50 Event IDs and Event Names. What I want to do is to see if the 50 events in the ...

**1**

vote

**2**answers

446 views

### VLOOKUP a HYPERLINK formula

Not sure if this has been asked yet, but I am trying to do a VLOOKUP in an IF to return a Hyperlink.
Sheet 1, Cell A2
=IF($C$1>=1,VLOOKUP($A$1,'Sheet 2'!$A$1:$B$5,2,FALSE),"")
Sheet 2
B1: =...

**0**

votes

**0**answers

631 views

### Excel - Automatically sorting

I am making a table for outcomes but I don’t know how to make my idea reality.
I want to have 2 sheets. First sheet is where to write the outcomes and it should looks something like this:
On the ...

**0**

votes

**1**answer

50 views

### VLOOKUP on each cell and sum

Let's say that I have a row of letters. And I have a table that matches each letter with a number.
How can I perform a SUM() of all letters?
Example:
A | G | A | N | G | ...

**0**

votes

**0**answers

76 views

### Vlookup, Match or Countif - compare 2 UNORDERED columns return differences in third column

Macbook Excel. I need to compare two columns of names, Column A and B to determine which names are in Column A but not in Column B. Case sensitivity won't work since some names are all caps or ...

**-1**

votes

**1**answer

66 views

### How do I assign a number cell to a text cell

I have imported data from the web on the Peruvian Football League which will refresh and update. I have taken an average % of 2 samples of data for each team. I also have a fixture list and want to ...

**2**

votes

**1**answer

321 views

### Excel - Increment vlookup column index when dragging down

I have a vlookup which needs to check the next column to the right each time it is dragged down a cell. So if the vlookup is first entered in cell A3 then it would be:
=vlookup($A$1, $A$1:$E$1, 2, ...

**0**

votes

**1**answer

31 views

### Filter Out Values by Category into new Table with vlookup

I have the following data that contains a list of Agents and their respective Manager:
I need to filter out the agents by manager and put them into a new table for each Manager?
I tried with the ...

**-1**

votes

**1**answer

87 views

### retrieve the entire column data If a particular text or pattern is matched

I have particular header(specific column) need to retrieve the entire column of the header to another sheet.Is there any formula to do it.

**1**

vote

**2**answers

109 views

### VLOOKUP returns #N/A when criterion is a reference

LibreOffice Calc 5.1.6.2
I want to use VLOOKUP function with criterion being a reference to a cell again containing a reference. But it doesn't work, it returns #N/A. Interestingly, when I replace ...

**1**

vote

**1**answer

84 views

### Excel vlookup matches only if verification is on first column

I notice this problem while using this vlookup function in excel 2016:
=IFERROR(VLOOKUP(A:A,Sheet2!A:B,2,FALSE),"NO MATCHING")
So the function will check into the range A:B, and if the match is ...

**0**

votes

**1**answer

50 views

### Find max value across multiple spreadsheets and return contents of adjacent cell

I have six spreadsheets (named, Book 1, Book 2, Book 3 etc), all with identical tables, that track a book's Amazon ranking each day.
Date. Rank. Genre.
On a summary page, I'd like to return the ...

**0**

votes

**1**answer

43 views

### Excel decimal precision secretly exceeding 15 digits and breaking VLOOKUP

I am doing some midpoint math using this formula
A1-MOD(A1+(Constants!$A$1/2),Constants!$A$1)
(Where values in column A are decimals and the value in Constants!$A$1 is an exact integer)
Then ...

**0**

votes

**1**answer

242 views

### How to add value to same cell in Excel

I frequently do stock audits in my store by scanning barcodes into Excel. I use the Vlookup() function to avoid data errors. At times, I scan the same barcode again and again, always adding just one ...

**0**

votes

**0**answers

154 views

### Mysterious table array definition in VLOOKUP formula?

I've inherited an Excel spreadsheet which contains the following formula, which I'm trying to debug:
=VLOOKUP($G$3,AllFE,79,FALSE)
I understand every part of this formula except theAllFE (table ...

**0**

votes

**0**answers

24 views

### want to compare 2 columns and replace data in a 3rd column with data from a 4th column

I want to compare some Acct Names and replace data in one column that is in relation with one acct name column with data from another column in relation to the 2nd Acct name column. So basically ...

**2**

votes

**1**answer

71 views

### Creating a repeating vlookup table for raw materials

I want to achieve the following.
User selects the item they want in A1 (dropdown menu), called ITEM1
In the second sheet, there are tables with the following properties such as
ITEMS MATERIALS ...

**0**

votes

**2**answers

87 views

### EXCEL: How do I find and match 2 different lookup values that are in separate columns?

I have two tables. one with 2 columns and the other with 3 columns.
T1C1(table1&column1) have mix of T2C1 and T2C2. I need to match T1C1 with T2C1&T2C2 and return the T2C3 values to T1C2.
...

**1**

vote

**1**answer

1k views

### Return a value with Vlookup, then subtract the value from the cell above it

I am trying to subtract one value from another in cells on a different sheet. I'm returning the first value using a vlookup
=VLOOKUP(Homepage!A2,Data!A:D,2,FALSE)
And I need to then subtract the ...