**0**

votes

**2**answers

121 views

### Trouble getting VLOOKUP to work

I’m trying to create a formula in Excel and I am having problems with it - think from previous posts it is a vlookup but can't get this to work as I hoped it would.
In sheet 1 (called raw data (2)) I ...

**4**

votes

**4**answers

48k views

### Excel - How to vlookup to return multiple values?

I'm looking to use Excel to look up and return multiple reference values for a given key. VLookup does something very similar to what I need - but only returns a single match.
I assume it'll involve ...

**0**

votes

**1**answer

24 views

### Can I use VLOOKUP to return a table name that is then used in an INDEX formula?

I have an INDEX formula like this:
=INDEX(Data3,MATCH(G4,Sheet2!$A$14:$A$17,0),VLOOKUP(F4,Threshold,2,TRUE))
However, I want to apply this to data where the table I want the INDEX formula to ...

**1**

vote

**1**answer

17 views

### How to CONCATENATE a VLOOKUP and have the lookup take place without an CR after a copy and paste value

A B C
=VLOOKUP(C1,B6:C8,2) =VLOOKUP(C1,B6:C8,2) =VLOOKUP(C1,B6:C8,2)
=VLOOKUP(D1,B6:C8,2) =VLOOKUP(D1,B6:C8,2) =VLOOKUP(D1,B6:C8,2)
=VLOOKUP(A1,B6:C8,2) ...

**0**

votes

**1**answer

31 views

### How do i do a “tweaked” VLOOKUP?

So here is the problem: I have 3 lists (adjacent columns) in a spreadsheet.
The 1st list contains the values I am searching for
The 2nd list contains the first half of table array which I am ...

**1**

vote

**4**answers

175 views

### Lookup returning #n/a - would like cell to be blank

I am using this formula to look across multiple sheets and return the value:
...

**3**

votes

**1**answer

469 views

### Excel: Why is VLOOKUP returning inconsistent and unexpected results?

I'm automating an Excel column to assign account values based on the vendor paid. For instance, if AT&T gets paid, the account value is Utilities:Telephone, and when the post office is paid, the ...

**0**

votes

**1**answer

44 views

### Searching for a value across 2 tables in Excel 2010, returning yes or no

I have one workbook with 3 separate worksheets
Sheet 1 contains 2 columns.
Column A has a range of unique alphanumeric identifiers.
Column B has a range of non-unique numbers.
A B
...

**1**

vote

**2**answers

107 views

### VLOOKUP or INDEX MATCH doesn't update columns when referencing pivot table

I'm going bonkers trying to figure this out. I thought I hit the jackpot when I learned about Index match and the additional flexibility over VLookup, but that flexibility doesn't seem to help when ...

**1**

vote

**2**answers

1k views

### Excel: VLOOKUP and INDEX+MATCH return #REF

I am trying to make cells in one sheet look up a name in another sheet, and return the value one column to the right of the cell with the name. In itself, a perfect job for VLOOKUP. But, when I ...

**1**

vote

**1**answer

207 views

### Excel access.Vlookup? IF?

What I am looking to do, is to move stuff from one excel sheet to another sheet, in the same workbook.
We will call the sheet with the data the "suppliers list" and the sheet where I want it to go, ...

**0**

votes

**1**answer

38 views

### How to find a specific row in Excell

I am looking for some formula in Excel like
give me the number of the row which its first column is 5 and its second is 3
I have searched the web but I have found lookup, search, find and ... which ...

**0**

votes

**1**answer

31 views

### How do I fix this VLOOKUP that returns last row value for date lookup?

I am running into what seems to be a very basic issue with Excel's VLOOKUP function (Mac Excel 2011). I've downloaded historical stock prices from Google Finance for Microsoft and then copied that ...

**6**

votes

**2**answers

30k views

### Quick replace #N/A by 0 when vlookup

I use vlookup a lot in excel.
The problem is with #N/A value when the seek value is not found.
In that case, we often replace it by 0 using
if(isna(vlookup(what,range,column,false));0; ...

**2**

votes

**2**answers

7k views

### Excel VLOOKUP by second column using table name as range

Using the example table below, I can use the formula =VLOOKUP("ABC123456",Table1,3,FALSE) to lookup the Demand value, but I want to do be able to perform the lookup by using the Cust Part field ...

**0**

votes

**3**answers

113 views

### How to use =VLOOKUP under these circumstances?

So I know how to use =VLOOKUP when you are searching for a single value within a cell, but I'm not sure how to do it when I have a range, ex. say the cells value is 1-5, the next is 5-10.
This is ...

**1**

vote

**2**answers

11k views

### Searching for a value in Excel, returning yes or no

I have one workbook, with two separate worksheets. I want to know if the values that appear in worksheet B also appear in worksheet A, if so, I want to return a "YES". If not, I want to return a "NO". ...

**0**

votes

**3**answers

75 views

### Find entity in a list of entities and give back another cell value based on which category it belongs to in excel

I want to find a nice way to get a specific value based on a category and another characteristic. I'll try to to exemplify it below;
Problems:
1) I want to check what category a certain entity ...

**0**

votes

**0**answers

256 views

### Lookup across multiple sheets and return a value to the left (Left-lookup)

I can use the following array formula to lookup a value across multiple sheets (I'm using the defined name 'ProductLines' for my sheets) and return any value in the same row in columns to the right of ...

**0**

votes

**2**answers

103 views

### Enhanced Vlookup Excel Formula

I am looking for an excel formula that I can use to automatically fill E2 in the screenshot below. The intention is to find Marc's age from column B, ie E2 should be 20. Any ideas please? I have tried ...

**0**

votes

**1**answer

52 views

### Can't get VLOOKUP working with roster spreadsheet

I have an Excel spreadsheet set up as a roster. The way the roster is setup is for the ease of the person creating the rotation. This roster is not easy to read for the staff.
Mon ...

**1**

vote

**2**answers

72 views

### Searching a value in a column in Excel

I have values in A1:A1000 and I have another column of values from B1:B500.
I want to check whether A1 is present in B1:B500; if it does I should get as PAID if it doesn't I should get NOT PAID. ...

**0**

votes

**3**answers

1k views

### VLOOKUP using CONCATENATE values

I have workbook1 with 3 values (columns) concatenated to 1 cell as =TRIM(CONCATENATE("ABC","-",$B174,"-",$A174,"-",$E174)).
Workbook2 has 1 cell that contains the concatenated value from workbook1.
...

**0**

votes

**1**answer

231 views

### =VLOOKUP() function performed on dollar value displays value without “$”

I'm not entirely sure how to present pleasant-looking spreadsheet representations on SE, so I would appreciate any advice on that issue given on the side.
I want the B2 cell to display the salary ...

**0**

votes

**1**answer

64 views

### merge two exel sheets and update duplicate value

I have two exel sheets and I need to merge this sheets but in sheets 1 i Have 800 records in sheet 2 i have 20 records and some of value from sheets 2 are duplicated in sheet 1. I wan to update ...

**0**

votes

**1**answer

135 views

### Compare multiple columns with another sheet and if matched return true

I have a sheet named Test with columns
[Category],[SubCategory],[Name], [Is in share?]
that need to be compared(except for the column [Is in share?]) with
the sheet named Share.
Share also has ...

**1**

vote

**2**answers

279 views

### Working with “~” in excel

I have a data set that has names that contain ~ within them. Unfortunately, I cannot find a way to filter or incorporate these cells in a formula.
For example, I tried to use a text cell that had ~ ...

**0**

votes

**0**answers

59 views

### Sum of Multiple VLOOKUPs

I am trying to find a formula that would help me sum the results of multiple VLOOKUPs. For example, you have two sheets that look like the following:
Sheet1
Fruit______ Orange_Apple_Banana
...

**1**

vote

**2**answers

377 views

### Excel Vlookup for 2nd, 3rd, 4th or 5th text value, instead of 1st matching value

I have rows of possible duplicate employee ID #'s, with another column of different values for the same person. I need a single column of unique ID's with the certifications transposed in the same ...

**0**

votes

**1**answer

1k views

### Excel 2010 vlookup formula - Using variable table array as input

I been trying to find out if its possible to automatically expand the table_array on this VLOOKUP formula:
=VLOOKUP(B2,Sheet2!$F$4:$G$965,2,FALSE)
I'm calling the values from Sheet2 to add into a ...

**0**

votes

**1**answer

91 views

### Copying VLOOKUP formula in multiple sheets, where sheet number automatically changes

I have created a progress card in Excel (there are 50 such sheets, one each for 50 students). There is one tabulation sheet also with the names of the 50 students. So, when numeric marks are entered ...

**1**

vote

**2**answers

134 views

### Count unique values in column B with respect to column A [duplicate]

I have two columns in Microsoft Excel, A and B. The input is displayed below
A B
ABC 1
ABC 1
ABC 2
ABC 2
ABC 2
DEF 1
DEF 3
DEF 3
CDE 1
CDE 2
CDE 3
CDE 4
I ...

**1**

vote

**1**answer

44 views

### VLOOKUP not interpolating all cells?

My VLOOKUP formula is not interpolating all cells
AD AE AF
11-6-2014 15:20 90,4 #N/A
11-6-2014 15:21 89,1 #N/A
11-6-2014 15:22 90,4 Good
11-6-2014 15:23 89,1 Good
AF column is my ...

**0**

votes

**0**answers

67 views

### Excel 2D-lookup on a PivotTable with changing coloumns and rows

I want to do a Vlookup on a 2D pivot table but neither the coloumns and rows of the pivot are fixed and are subject to change due to ever changing data source. How can I perform a accurate vlookup on ...

**0**

votes

**1**answer

56 views

### EXCEL MAC: VLOOKUP copying the date instead of the data

First of all, am sorry if this was already posted by someone else, I tried searching for hours now, but did not find something similar to what I have here. I am very newb on excel.
My problem is, I ...

**1**

vote

**2**answers

2k views

### How to get VLOOKUP to return the *last* match?

I'm used to working with VLOOKUP but this time I have a challenge. I don't want the first matching value, but the last. How? (I'm working with LibreOffice Calc but an MS Excel solution ought to be ...

**0**

votes

**1**answer

100 views

### Excel: How to find a range, from a list of ranges, that a value is in?

I hope someone can answer my question!
I have lots of values and need to know which ones lie within a list of ranges and if so which range do they lie in.
For example: worksheet 1 contains my ...

**0**

votes

**0**answers

49 views

### Vlookup from formula in Excel 2010

I would like to use a vlookup, where the value being looked up is the result of a formula, however my formula below results in an error.
It works if I type in the result of the formula, but not for ...

**0**

votes

**1**answer

2k views

### Lookup list dependant on the contents of another cell

hope someone can help to crack this one?
I've got a table on my data entry tab (sheet 1) where each row includes two data validation drop down lists (source is on sheet2). I want the options in the ...

**0**

votes

**1**answer

217 views

### Excel SUM From Different Sheets IF Date Found

I have a workbook with separate sheets for each product (about 20 sheets, adding more on a regular basis). Each product is only available for a certain time frame, and has daily sales data recorded on ...

**0**

votes

**1**answer

86 views

### In Excel selecting an item from row when cell matches the first item in that row

I have a LIST of 5 optional sizes. There are several numbered mating parts that coincide with each of the sizes forming a pair. Any 1 of the mating parts can go with a chosen size, but only 1. Some ...

**0**

votes

**1**answer

63 views

### Convoluted Date Lookup

I found this, which is pretty close, but I don't know VB, so I'm trying to do this with a vanilla formula.
First worksheet has a series of tables of unemployment rate: 1 per US state. Each table ...

**1**

vote

**0**answers

37 views

### Trouble adding values from different ranges in excel

I have a fairly unique problem I am having trouble with.
Essentially, I need to fix column U on Sheet 1. Ignore stuff out of the tables, as most of that is stuff I either will hide but reference, or ...

**-5**

votes

**1**answer

32k views

### How do I compare two columns in Excel to find if there is corresponding data?

How do I compare two Excel sheets to detect whether the data in column B of sheet 2 appears in column A of sheet 1?

**-1**

votes

**1**answer

417 views

### With VLOOKUP, if N/A, keep original value

I'm using Vlookup to find a value, but when it doesn't work, it returns N/A. How do I keep the previous value instead of having NA. I have found the answer HERE
How do I implement this? Do I just ...

**1**

vote

**1**answer

267 views

### In Excel 2011 on Mac, how to return a non-blank matching value with vlookup?

I have a list of domain names and their registrars on one sheet, and the same list of domains and other data (but not registrars) on another sheet.
I need to get the registrar name from sheet A, to ...

**0**

votes

**2**answers

250 views

### MS Excel using multidimensional lookup

Hi am trying to assign a value given that if I have a some value that matches column 1, it will search try to check if for that specific row my my product variable is lesser than specified.
So let's ...

**0**

votes

**1**answer

440 views

### Merge rows and join matching values

I have two sets of data on the first set there is one column that has a list of IDs like below.
I have another set which could have several rows matching that same ID like below
I am trying to ...

**0**

votes

**1**answer

403 views

### Excel 2013: VLookup for cells that share common characters within cell but are both surrounded by other non-matching text

I am pulling information from 2 different databases. The databases use different naming protocol for the exact same item/specified placement however they always have certain components of the name in ...

**0**

votes

**2**answers

80 views

### vlookup with blank look up value

I have a Vlookup running and I want it to return 0 if the look up value is empty.
example:
=(VLOOKUP(A6,F:G,2,0)+1)*C6
+-------+--------+-------+-----------+-------+-------+
| | | ...