**0**

votes

**2**answers

31 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

203 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

90 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

109 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

53 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

221 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

48 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

31 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

47 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

212 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

57 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

62 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

135 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

311 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

245 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

81 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

49 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

106 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

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

**-4**

votes

**1**answer

4k 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?

**2**

votes

**0**answers

246 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

**0**answers

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

**-1**

votes

**0**answers

15 views

### using VLOOKUP for finding differences between two words arrays

Please, help me to figure out how to correctly use formulas (like =VLOOKUP() or =MATCH() ) in order to compare array of words in column A with array of words in column B and a return difference ...

**-2**

votes

**0**answers

42 views

### Looking for formula in Excel to take the set of cells in the row and check for a match in a column

For each row in my spreadsheet I want to use a formula to check the values in the 17 columns B:R for a match in a smaller vertically oriented table and then check to see if the corresponding value in ...