The lookup tag has no usage guidance.

**-1**

votes

**0**answers

12 views

### Unexpected result from Google Sheets MATCH function

When I use Google sheets' MATCH function to look up the row number for a value in a column, the wrong row number is returned.
Example:
MATCH(Q10;A:A)
where Q10 has a value 'thuja plicata'
This seems ...

**0**

votes

**3**answers

123 views

### Excel multi table lookup, can you find a more elegant solution?

This is partly for fun, and I hope it doesn't get closed on subjectivity grounds because although "which solution is the most elegant" is subjective, "the current solution is convoluted and ugly" is ...

**1**

vote

**1**answer

56 views

### Need a Lookup Function

I'm looking for a lookup function for cell K5. I want a percentage number based on the relationship between "Planned #Rep", or B5:B15, and "Actual #Rep", or E5:E15, using the bottom chart as a ...

**0**

votes

**0**answers

44 views

### Search tool using keywords on Excel data or a keyword based corresponding code and description search : The file needs permission

I am a basic level Excel user. I need some help on preparing a look-up tool using keywords as described below:
I have a list of 1000 different product/service descriptions along with their respective ...

**0**

votes

**2**answers

36 views

### How to make excel SUMUP values of multiple rowkeys in a two-dimensional lookup to return sumed up values in a corresponding cell

So I have this challenge with a set of data arrangement and by merging the VLOOKUP and MATCH strings I was able to get my result but there is a little hiccup!
Pasted below is the merged string that ...

**-1**

votes

**1**answer

35 views

### Excel lookup table based on time

I need to set up a way that I can tell which shift certain things happen in. I have a table that has all the times, but I would like to attach each time to a shift (i.e. if this happens between 14:00 ...

**6**

votes

**5**answers

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

**2**

votes

**1**answer

93 views

### How to Index-Match upwards from a specified cell until non-blank

I've got data in sort of a directory tree layout (See picture)
Basically I want to use one lookup code as a reference point and have excel look upwards in the respective columns to display the "...

**3**

votes

**1**answer

38 views

### How can I look up the 2 axis values by inputting a number?

I'm a graphic designer and not very familiar with Excel but I'm fairly sure it's the simplest solution to my problem. I have a table (see below) with 2 axis going from A to L. Inside that table are a ...

**2**

votes

**2**answers

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

**2**

votes

**0**answers

79 views

### Chrome - Selected Text - Right Click [LOOK UP] - How to disable

After some recent update Chrome fro Mac got this SUPER ANNOYING feture. When you select text and right click it, menu comes up. I often used "Search Google for" but now the first thing in menu is LOOK ...

**13**

votes

**4**answers

72k views

### Inverse ARP lookup

How can I do an inverse ARP lookup in Windows and/or Linux? Say that I have the MAC address of wireless access point which is up and running in the network, but I forgot it's IP address?

**0**

votes

**1**answer

30 views

### Excel Lookup for work sheet comparison

I have 3 sheets. The first one contains data for Shop A, the second data for Shop B, and the last sheet contains the results.
Sheet A & B: Item Code, Name, Brand,and Stock
I want to compare ...

**3**

votes

**1**answer

3k views

### Excel 2013 Fuzzy Lookup to find near-duplicate text

I have a list of captions with a large number of near-duplicates. For example:
Birthday for Her
For Her Birthday
Birthday - For Her
For Her / Birthday
I was looking into Fuzzy Lookup as a way ...

**9**

votes

**1**answer

589 views

### Where can I obtain the full DNS zone files for all TLDs?

Is there a way to get full zone files for all TLDs? I have managed to get my hands on a few (.com, .net, .org), but I'd really like to get some of the country-specific ones for having a play around ...

**0**

votes

**1**answer

34 views

### in ms excel, is there a way to look up an array and edit data on the looked up row?

Just for a quick example, I have this table:
A B
1 student grade
2 john 90
3 paul 93
4 peter 87
5 bill 84
6
7
Range or array is A2:B5.
I ...

**1**

vote

**1**answer

89 views

### Windows 7 lookups on first host file entry

Today my ISP blocked my internet due to suspicious activity - outgoing requests to malicious websites. Numerous scans of my machine couldn't reveal the culprit.
However, after doing a quick netstat /f ...

**0**

votes

**4**answers

823 views

### Getting last cell in row with data and corresponding data in column A in Excel

I have a spreadsheet that in column A lists dates. Column B may or may not have data in each cell.
The question I have is when I grab the last cell with data in column B, how can I also grab the ...

**0**

votes

**1**answer

93 views

### How to find a specific row in Excell

I am looking for some formula in Excel like
give me the number of the row which its first column is 5 and its second is 3
I have searched the web but I have found lookup, search, find and ... which ...

**0**

votes

**1**answer

43 views

### Looking up the row number of a shared identifier in Excel, and counting the number of cells in that row that meet specific criteria?

I have a sheet that contains a lookup value in columns. I want Excel to look for each value in another sheet, and count the number of instances of a certain word in the row in which it found that ...

**0**

votes

**1**answer

284 views

### Combining address function and cell function in Excel

In MS Excel 2013, when I write
=CELL("contents",$B$1)
It is okay, but when I write
=CELL("contents",ADDRESS(1,2))
It results in error. I would like to access the contents of an address. I have ...

**2**

votes

**4**answers

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

**1**

vote

**2**answers

10k views

### How do I use Expression Builder in Access to create a LOOKUP function?

I recently moved from Excel 2007 to Access 2007 to manage what never should have been spreadsheets. Unfortunately, from what I can tell, the LOOKUP function in Excel does not exactly work the same as ...

**2**

votes

**2**answers

146 views

### How can I get information from one cell in a row, based on the clue of 2 other cells in the same row?

I'm trying to get Excel to give me information in Column C based on the values in Columns A and B.
Cell A and Cell B will contain duplicates, and what I'm trying to do is build a formula which finds ...

**1**

vote

**1**answer

169 views

### Excel lookup() always returns last value

I am using Excel on a larger table (3148 col) and I am doing a lookup.
I've tried it with just 10 columns and it worked as expected but when I do my lookup with all the entries it just fails by ...

**-1**

votes

**1**answer

212 views

### Finding the largest value in a 2-dimensional range and returning the column header

I've been struggling to find a solution to locating the maximal number within a 2-dimensional range and then looking up the column header that the maximal number falls into.
For example:
I'm ...

**2**

votes

**4**answers

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

**0**answers

79 views

### Domain name lookup as another domain name

In Windows (8.1) hosts file contains mappings of IP addresses to host names.
For example:
127.0.0.1 example.domain.net
What I want to achieve is to map a domain name to another domain ...

**2**

votes

**2**answers

2k views

### Dos executable lookup except PATH

I have a cmd open (Windows 7), and I type "java.exe", and the system finds the executable at c:\program files\java\jre6\bin.
However, this folder is not in the path. What other mechanism affect the ...

**1**

vote

**0**answers

43 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

690 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

81 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

226 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

88 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

**1**answer

2k views

### How to automatically populate a lookup column in Sharepoint 2013

I have 2 Sharepoint lists in SP2013: Errors and Locations. The errors list has a lookup column to the locations list. I need the location information (phone, address, etc) to populate automatically ...

**1**

vote

**3**answers

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

535 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

119 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

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

**0**

votes

**1**answer

75 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

**1**answer

3k views

### Retrieve content of different cells based on input

I have a cell X where the user can enter a number. I then need to take that number N and get the value of another cell Y based on that.
The scenario is this:
The user can enter a product number and ...

**2**

votes

**4**answers

995 views

### Is there any free reverse DNS lookup service (DNS replication)? [closed]

I want to find all domain names that were resolved for a specific IP.
How to do such a search? There is any free service/tool for that?

**0**

votes

**1**answer

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

**3**

votes

**2**answers

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

**3**

votes

**4**answers

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

**0**

votes

**2**answers

217 views

### Camera control box plugged into the router, any idea how I can find its IP?

In the past I've used it but recently I got a new router. I plugged the camera control box in, and it has an internal webserver to configure it. However I just have no idea what its IP address is. I ...

**2**

votes

**2**answers

2k views

### DNS Lookup over SSH Tunnel

On Linux or Mac OS X how can I perform DNS lookups over an established SSH Tunnel?
How can I restrict DNS lookups of the form *.mydomain.com
Can I redirect all attempts to access domains of the ...

**0**

votes

**2**answers

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

**1**

vote

**1**answer

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

**3**

votes

**4**answers

8k views

### Problem with network shares

I have a laptop installed with Windows 7 that has problems in accessing network shares. Even if I am able to ping the computers containing the share then I get the infamous "Windows cannot access the ....