Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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
0answers
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
2answers
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
1answer
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
0answers
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
1answer
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
2answers
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
3answers
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
2answers
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
2answers
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
1answer
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
2answers
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
1answer
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 ...