# Tagged Questions

**0**

votes

**2**answers

218 views

### VLOOKUP with multiple criteria

I have a workbook with 2 sheets: spg and data
From the data sheet I wish to do a vlookup in the spg sheet, based on the value of multiple columns in spg.
I can do a =VLOOKUP(H5,spg!$D:$I,6,0) but ...

**0**

votes

**1**answer

49 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

**3**answers

105 views

### Lookup range of words in range of sentences

Based on the following example:
I want to look up for words from the $D$2:$D$6 range in sentences from the $A$2:$A$8 range and use the value from the side column (here Tag). So far I'm doing this:
...

**0**

votes

**1**answer

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

**1**

vote

**2**answers

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

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

**1**

vote

**2**answers

83 views

### Forcing consistent format for lookup values and lookup arrays

I have this annoying issue where I need to look up values in a column that contains both numeric and alphanumeric data. For instance:
1234567
P654321
7654321
V234567
..and so on.
This column is ...

**0**

votes

**1**answer

79 views

### Merge multiple tables by comparing multiple rows

I have multiple three column tables that share two rows in common:
DailyCosts: DailyPrices
CodeRole CodeRegion DailyCost CodeRole CodeRegion DailyPrice
1 1 ...

**0**

votes

**1**answer

466 views

### vlookup and indirect and external shared workbooks

i have two excel workbooks that are both shared in our company folder.
excel1 is where each employee has his own page to fill information and column 1 of each page is the row reference
excel2 is a ...

**0**

votes

**1**answer

145 views

### Vlookup not working as expected for soccer data

i have a vlookup function that is supposed to give me some data from another worksheet. the worksheet contains soccer data, specifically about the european cups of the past 3 years (9-10, 10-11,11-12, ...

**0**

votes

**1**answer

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

**1**

vote

**2**answers

6k views

### How do I prevent vlookup returning 0 for values that are blank in the lookup data? [duplicate]

My vlookup call in an Excel 2010 spreadsheet is returning a value of 0 for values that are blank in the lookup data.
How can I force vlookup to return a blank when the data is blank, and 0 when the ...

**2**

votes

**2**answers

192 views

### Excel 2010 - VLookup, Search and Match are doing things beyond my imagination

I have two worksheets, one containing a list of e-mail addresses and information, the other containing e-mail addresses that should be blacklisted. To remove the blacklisted e-mail addresses I thought ...

**-1**

votes

**1**answer

72 views

### if statement containing multiple lookups

I need to create a formula that has three lookup criteria. I have one source document, called "Sales Force". I want to know if the value in A1 is in column AA of Sales force tab, if not, then look ...

**2**

votes

**0**answers

248 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

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

**1**

vote

**2**answers

711 views

### Edit referenced cells in master worksheet from derived worksheet in Excel

I'm using Excel 2010 and I have two worksheets. Sheet A has a unique identifier column and other columns with values. Sheet B has a list of identifiers and other fields for which I'm using a VLOOKUP ...

**0**

votes

**1**answer

148 views

### Use Excel to select the most recent row from a CSV?

I have a CSV that starts with a date/time field and I need to import, and select the most recent row and refer to it in my formulas.
I'm experimenting with Pivot Tables, and just now Rank and ...

**1**

vote

**1**answer

930 views

### MS Excel 2010: VLOOKUP not working right?

Here's the data that I have on the "Components" sheet (B4:E13):
Component 1 a Form Low
Component 2 a Form Low
Component 3 a Form Medium
Component 4 a ...