**0**

votes

**2**answers

49 views

### How to lookup a value and return multiple unique values to a single cell - comma separated

I am attempting to lookup a unique identifier (Product Number) which is held in several different stock locations. For example:
__A__ __B__ __C__
1 Item # Warehouse ...

**0**

votes

**1**answer

23 views

### VLOOKUP returning N/A because references contain “.” and “ ” in one table, not in other

OK
I am trying to vlookup a table but the problem is the references on one table are slightly different to the references on the other table. I can get the VLOOKUP function working, but it is ...

**-1**

votes

**0**answers

14 views

### Vlookup Advance Help - Extract all different values against 1 lookup_value

Well we all know about vlookup using this we can extract specific value against any one But i want something extra in this like like when i use this i get the only first one value against my ...

**0**

votes

**1**answer

33 views

### How do I set a dropdown in excel to populate different data in cells below based upon the option selected from the dropdown?

I am attempting to clean up a spreadsheet that we have that tells us what permissions to grant for certain roles in our ticketing system.
I have used the Data Validation tool to create my dropdown ...

**0**

votes

**0**answers

19 views

### Excel vlookup in two access tables

What i want to do is use vlookup in Excel with data from two tables in Access. Vlookup will search for a first/last name field into both those tables and return info from them. I can't seem to find a ...

**0**

votes

**1**answer

113 views

### How to return all the cells in a row if first column matches a value on another worksheet

I have 2 worksheet tabs in an Excel workbook, tickets and tickets info. I have values in Column A of tickets (from A2:A500). I want to search for each value from A2 to A500 of the ticket sheet looking ...

**0**

votes

**3**answers

31 views

### EXCEL VLOOKUP returning #NA when IF condition specifies “ ”

=IF(VLOOKUP(D4,'[05.14_Wave 5 Priority 14 (Big+Cranberry) Specifications.xlsx]Big'!$B:$B,1,FALSE),"Project
BIG",IF(VLOOKUP(D4,'[05.14_Wave 5 Priority 14 (Big+Cranberry)
...

**0**

votes

**1**answer

25 views

**-2**

votes

**0**answers

56 views

### lookupvalue and return multiple values in Excel do not work

I need to pull through multiple unique IDs for expenses. i.e. one timesheet consists of 5 expense payments for one date, but each of these expenses for that day contain individual unique ID. I need to ...

**1**

vote

**0**answers

22 views

### Speeding up Vlookups

When you do a Vlookup on a large database of say 80,000 rows, its gets slower and slwer as weach time it starts from the top and works through til it finds it. If its ordered then the first time its ...

**1**

vote

**1**answer

73 views

### How do I align two tables based on a unique column with Excel?

I have two tables in excel, the first is a complete list of products with some basic info, the other has only selected products in and more information about them, but is lacking some of the ...

**1**

vote

**1**answer

58 views

### Align rows from different columns (which contain some cells that have identical values) using simple formula in Excel

I have 2 tables in Excel and I am trying (via Excel formula) to match/align some rows (ones that contain identical letters for the sake of the example included below). Btw, I don't mind aligning Table ...

**0**

votes

**2**answers

101 views

### In Excel, how can I check and output the list which are different between two columns?

Eg. I have List A and List B.
List A includes (1,2,3,4,5)
List B includes (6,2,3,4,0)
I want the output which are not in the list A: 6,0
Without returning error like in vlookup.
Thanks in advance! ...

**0**

votes

**1**answer

54 views

### Is there a way to exclude keywords in a VLOOKUP formula?

I have 3 sheets in Excel. In the 1st one there is a column with hotel names and another one with ID. I want to get that ID from the ID column on the 2nd sheet where I have the names as well.
The ...

**0**

votes

**1**answer

131 views

### VLOOKUP - return multiple values/columns for one row/match of data

I'm trying to figure out how to pull multiple columns to my target sheet when using VLOOKUP. for example
I have a list of employees on sheet one, with 100 rows of data and want to pull details about ...

**-1**

votes

**1**answer

58 views

### Formatting - conditional - vlookup- values from one cell to another different worksheets based on value

I would like to be able to enter a part# in column L of sheet 2 and a formula would look through column A of sheet 1 for a match, and then return their price from column F of sheet 1 into column K of ...

**2**

votes

**1**answer

39 views

### Not getting desired output with VLOOKUP - Need assistance

I have Table 1, which looks like this -
A1 B1 C1
1 X Date11
2 Y Date12
3 Z Date13
I have another table, Table 2, that looks like this -
A2 B2 C2
1 M Date21
2 N Date22
3 X ...

**-1**

votes

**1**answer

60 views

### Excel Vlookup range or if function

I have been struggling to find a formula that works for the example below (see question mark!). What i am trying to do is merge 2 datasets. The problem is that the common identifiers are not always ...

**0**

votes

**1**answer

26 views

### Excel Formula Is unwantedly automatically changing

I have created a product referral log and needed to have a system that automatically calculates points for those products once they are closed.
My solution for this was to make a separate sheet ...

**0**

votes

**1**answer

26 views

### in ms excel, is there a way to look up an array and edit data on the looked up row?

Just for a quick example, I have this table:
A B
1 student grade
2 john 90
3 paul 93
4 peter 87
5 bill 84
6
7
Range or array is A2:B5.
I ...

**0**

votes

**3**answers

48 views

### Excel multi table lookup, can you find a more elegant solution?

This is partly for fun, and I hope it doesn't get closed on subjectivity grounds because although "which solution is the most elegant" is subjective, "the current solution is convoluted and ugly" is ...

**3**

votes

**1**answer

117 views

### Excel, how to use text functions on lookup array without putting in another column?

If I'm using a vlookup, or a match function but I need to do some mumbo jumbo on my lookup material, is there a way of doing this in the lookup array without simply adding another column?
Let's say I ...

**0**

votes

**1**answer

24 views

### Vlookup column a and find highest version number in column b

I have a list of part numbers in column A: in column B is a version number of the part number. The part number can be repeated and the version number is unique. I want to lookup the part number in ...

**0**

votes

**1**answer

48 views

### Excel Index Match for multiple conditions evaluates correctly with F9 but not in cell

I have an index match formula that evaluates correctly if I use F9, however when I actually press enter it returns #N/A.
The formula is designed to perform a vlookup on two conditions:
...

**0**

votes

**1**answer

43 views

### Using vlookup / index match for this circumstances

I have some data which are grouped like this:
1st group of data(gender): Male, Female
2nd group of data(age): 12,13,14,15
3rd group (score + grade): For each gender and their corresponding age, ...

**0**

votes

**1**answer

45 views

### How can I search for a value that's repeated in excel?

I have a spreedsheet (Sheet2) that has 4 columns:
ID | Name | Semester | SemesterAvg | Overall Avg | Period |
1 | John | 1 | 2.5 | 2.5 | 20132 |
1 | John | 2 | ...

**0**

votes

**2**answers

181 views

### Needs VBA solution - Clear contents of 4 cells to left of cell with N/A Error

I have a table of data in which column L has a vlookup formula. In the rows where column L (i.e., the vlookup returns "#N/A"), I would like to clear the contents of the eight cells to the left ...

**0**

votes

**2**answers

112 views

### IF Statement with VLOOKUP

I'm trying to get a value from the ADD Taxable which is column 10 in the Check (sheet). I only want the value from column 10 if the Earn Type on Timecard (Sheet) has BONUS in it. I'm using the TC Ref ...

**0**

votes

**1**answer

51 views

### Excel 2013, Vlookup - accessing different sheets.within a workbook

I Have a cell (lets say its A1) that specifies (from a drop-down list) a Sheet Name (AA BB CC DD etc)
I want to pass that sheet name to a VLOOKUP Formula which would (if life were simple) be SOMETHING ...

**0**

votes

**1**answer

430 views

### How to lookup a value and return multiple unique values (remove duplicates) to a single cell - comma separated

I am trying to take a value (unique id) from column AC, do a lookup in column (B) and return (meaning concatenate) the multiple unique values from an adjacent column (C) to a single cell in column AD. ...

**-1**

votes

**1**answer

87 views

### I need a cell to automatically fill when data is entered into a neighboring cell

I would like cells E5-E39 to automatically fill with data in cell P1 when data is entered into cells B5-B39. So when something is entered in cells B5-B39, E5-E39 are auto filled with the info in P1.
...

**1**

vote

**2**answers

924 views

### I need todays date to auto fill in cell when data is entered into another cell

I would like to have cells C5-C39 auto fill the date when data is entered into cells B5-B39. I have tried to get it to work using =TODAY() but don't how structure the formula.
Thanks.

**0**

votes

**1**answer

94 views

### I need the number in a cell to countdown when data is entered into other cells.

I'm making a sheet to keep track of the number of software licenses.
In cell B1 I have the number 35 representing 35 licenses. As they are assigned to systems in cells C5-C40 I would like the total ...

**0**

votes

**1**answer

50 views

### Excel 2010 - VLookup -

I have two identities associated with one unique value in the table. I need to pull both the values in another sheet using vlookup - is that possible.
Here is the example:
Id Owner Name
A1 Owner 1
...

**0**

votes

**1**answer

73 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

83 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

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

**0**

votes

**1**answer

88 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

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

**0**

votes

**1**answer

64 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

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

**0**

votes

**3**answers

157 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

75 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

**4**answers

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

**1**

vote

**2**answers

94 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

4k views

### VLOOKUP using CONCATENATE values [closed]

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

**0**answers

587 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

**1**answer

91 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

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

**0**

votes

**0**answers

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