**0**

votes

**3**answers

462 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

**3**answers

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

**1**

vote

**2**answers

45 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

**2**answers

178 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

**2**answers

267 views

### Find the different two Excel sheets when having identical row

I have two excel sheets with same column Names and Format. And it has one identical row(can use as Primary Key) id. I want to get the diff.
table 1:
id Name GPA
----+------+-------
1 | AA ...

**2**

votes

**1**answer

131 views

### Excel VLOOKUP using results from a formula as the lookup value

I have a cell that I must remove the first 2 characters "RO" for each value in a column on a sheet called RAW DATA and put into a cell on a sheet called ROSS DATA. Some of the values in that cell have ...

**1**

vote

**1**answer

180 views

### Excel access.Vlookup? IF?

What im looking to do, is 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, the ...

**1**

vote

**1**answer

62 views

### Excel fomularbar shows correct Value, Sheet shows VALUE error

Here is the data I have been using, data format all General:
Name Address
Adam 250
Mohame 150
Adam 220
Adam 423
Yasir 240
Ibrahim 236
Adam 242
Index formula cell B11 contains the ...

**1**

vote

**1**answer

260 views

### Excel 2007, Vlookup using a table to determine what to return

I want a pretty complicated puzzle and I'm not entirely sure it is possible, I would like to try and avoid making a macro and just use the functions but...
I want to have a table of information, 1 ...

**0**

votes

**1**answer

41 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

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

**0**

votes

**1**answer

66 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

**1**answer

77 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

197 views

### Count instances of a letter in a row if a certain cell in that row contains a specified date

I have a spreadsheet containing a column of dates (week commencing) with columns of data to the right of it, and a conditional formatting rule that highlights this week's row based on the date.
I ...

**0**

votes

**1**answer

287 views

### Converting Monthly data to Daily data on EXCEL for MAC

I have data columns of the last day of each month with a value. Apparently, the value of the entire month is stationary. I have to make a new column with daily dates while having the particular ...

**0**

votes

**1**answer

93 views

### sum values based in agent ID

I have a sheet with agent id's in column a and under each ID is a sub identifier with a value in column b of 1 - 7
sub identifiers are
Break_1000
Meeting_2000
Training_3000
Personal_4000
...

**0**

votes

**1**answer

362 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

**1**answer

70 views

### vlookup datetime FALSE; return value from 1 of two columns based on exact datetime

Based on data below, I am trying to do a vlookup such that if the datetime in ends in 18:59 return the value in column_3, if the datetime ends in 6:59 return the value in column_4...
10/7/2013 18:59 ...

**0**

votes

**1**answer

80 views

### How to use match & index or lookup function based on a number derived from a time calculation

I have created a gantt chart to use as part of my rota system. I want to be able to use a formula (either LOOKUP or MATCH & INDEX) to look up the hours worked against another sheet and pull in the ...

**0**

votes

**1**answer

398 views

### VLOOKUP within VLOOKUP

I'm trying to build a quick form to allow a user to calculate certain data using a data table. I am using LOOKUP and VLOOKUP to achieve this.
This is my current formula:
...

**0**

votes

**1**answer

751 views

### Excel matching between combination of columns

I have the following data on an excel :
Sheet1 :
id effectiveDate rateValue CrTime
20 20130627 0.08 6/28/2013 23:05
20 20130626 0.1 6/28/2013 6:23
Sheet 2:
...

**0**

votes

**1**answer

373 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

103 views

### Copy multiple data from one sheet to other without Multiple vlookup

I have two spreasheet and there are numbers of column on both the sheet, There is one common field (IDs) between those sheets. I can do multiple vlookup but would not like to do so because there are ...

**0**

votes

**1**answer

60 views

### Number grouped data using VLOOKUP?

I have a huge dataset with income brackets in column B and BMI values in column C:
totinc BMI
15600>18200 19.5
18200>20800 27.4
20800>23400 22
...

**0**

votes

**1**answer

124 views

### Using VLOOKUP to match a password with a user

I have two Excel worksheets in the same file.
One is a full list of Parents and their associated children.
The other is a list of Parents and their platform logins.
For some reason, I have a ...

**-1**

votes

**1**answer

70 views

### excel reference- VLOOKUP formula error

VLOOKUP is great except every time i try to input the formula, i get an error message, "you may not use references to other worksheets or workbooks for calculated column criteria" anyone know how to ...

**2**

votes

**0**answers

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

**1**

vote

**0**answers

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

**0**

votes

**0**answers

58 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

**0**answers

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

**0**

votes

**0**answers

51 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

**0**answers

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