0
votes
2answers
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
1answer
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
3answers
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
1answer
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
2answers
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
2answers
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
1answer
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
0answers
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
1answer
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
2answers
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
1answer
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
1answer
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 ...