# Tagged Questions

**1**

vote

**2**answers

36 views

### How to get VLOOKUP to return the *last* match?

I'm used to working with VLOOKUP but this time I have a challenge. I don't want the first matching value, but the last. How? (I'm working with LibreOffice Calc but an MS Excel solution ought to be ...

**0**

votes

**0**answers

18 views

### How can I select a column using a variable?

I am using the formula =LOOKUP(A5,Rota!A56:A81,Rota!I56:I81), where;
A5 holds a name
Rota!A56:A81 holds a list of staff names
I56:I81 is the number of hours worked by that person
This is repeated ...

**1**

vote

**0**answers

32 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

**2**answers

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

**1**

vote

**1**answer

50 views

### Excel - Lookup to match varying criteria

I have a list of poles, some with more than one test result. I want to find the latest test result for each pole and then return the result. As we know, VLOOKUP only finds the first. I don't want ...

**1**

vote

**1**answer

51 views

### Excel: What formula to use to return the minimum or maximum of a set of lookup values? [duplicate]

I'm looking for a way to calculate the values shown in cols D & E in the below screengrab. Column D contains the earliest date from column B where the name in column A matches. Similarly, column ...

**1**

vote

**2**answers

65 views

### Formula to search highest value related to a near match reference

I have a list of neutral references which change as per the date so
What I am looking for is a formula that will search Product and return the latest date.
e.g.,
A B
...

**0**

votes

**0**answers

32 views

### Select column without cell adjacent in Excel for Mac

I want to select the entire column to the left without the cell adjacent to the left to run a fuzzy-lookup. Of course I'd like to make that expandable, so I don't have to make it by hand. Here is the ...

**0**

votes

**3**answers

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

**1**

vote

**1**answer

208 views

### Find and return sheet name

I am looking for help in finding a string within a workbook and returning the sheet name (Address) or where the same can be found, e.g. Let's look for Lisbon which is located in sheet Portugal (sheet ...

**1**

vote

**1**answer

85 views

### Excel Lookup Not returning Proper Result

I have a simple lookup function, which I am using in place of a Switch Case statement.
Following is what I am trying to accomplish:
switch(F5){
case "apple":
return "1";
break;
...

**0**

votes

**2**answers

582 views

### Excel Lookup/Match exact match only

I am a bit confused with lookup/match and the lookup wizard in excel 07 does not seem to allow multiple sheets properly.
What I need is for cell B2:BXXXX on Sheet 2 to run the following and display ...

**2**

votes

**3**answers

3k views

### excel performance: Lookup Vs Getpivotdata

I build an Excel 2007 spreadsheet which contains a larger table with source data (about 500,000 rows and 10 columns). I need to extract data from this large table for my analysis. To extract and ...

**0**

votes

**2**answers

63 views

### Excel look-up column data

I have two data tabs for survey responses - the first shows the full set of exepcted responses an which office they are from
HMIP LDU
1 Leeds
2 Leeds
3 Leeds
4 Leeds
5 Wakefield
...

**2**

votes

**3**answers

4k views

### Excel lookup data from google docs spread sheet

Can excel lookup values from a spreadsheet in google docs? I would like my current excel forms to be able to lookup data from a spread sheet that used to be held on our server but now is a google ...

**0**

votes

**1**answer

253 views

### Lookup is failing to accurately use the lookup value

I am using two Excel workbooks; one is the backend for the other. In Book 1, there are sheets sheets with a $Timeline, $ClientInfo, and $VendorInfo. Book 2 is meant to be a summary record of different ...

**0**

votes

**2**answers

4k views

### Checking if any cell in a column of strings on one worksheet is contained in a column of strings in another worksheet

I have a column of strings in an Excel worksheet. I'm looking for a way to write a worksheet function (not VBA) that will allow me to tell, for each cell, if the value of the cell is contained in a ...

**3**

votes

**2**answers

196 views

### Excel lookup based on times

I have a table of data
number LowTime HighTime
2 0:10:10 0:11:23
4 0:11:24 0:12:55
I want to find in this table the number value for a given time
if I have in my cell 11:25 ...

**0**

votes

**3**answers

4k views

### How to use excel to disply a list of cells, depending on dropdown box selection

What I want to achieve:
select list A, B or C from a dropdown, when pressed, list of values displays underneath. I would also like the list to be populated from items in a table (which would have ...

**2**

votes

**2**answers

986 views

### Excel Table lookup with indexes in multiple columns

I have a Table in Excel the looks about like this:
Test1 100 test2 200
Test3 110 test4 210
Test5 120 test6 220
I want a function that, given test 1 as input, will return 100 AND given ...

**3**

votes

**4**answers

7k views

### Excel: Finding a value in a range of values

In my Excel document, I have one sheet containing a column of important dates. In another sheet I have a list of all dates. I want to conditionally format that list such that if the date is present in ...