The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
7 views

Lookup across multiple sheets and return a value to the left (Left-lookup)

I can use the following array formula to lookup a value across multiple sheets (I'm using the defined name 'ProductLines' for my sheets) and return any value in the same row in columns to the right of ...
-1
votes
2answers
17 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
4answers
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 ...
-1
votes
0answers
20 views

Returning a specific number id text is the same in different tabs

So what I am trying to do is if: Location A has the same location B then return the distance. Location A is on one tab and Location B is in the next tab. I want it to register same locations and put ...
0
votes
0answers
16 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 ...
1
vote
2answers
78 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
2answers
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 ...
0
votes
0answers
22 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 ...
0
votes
3answers
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
3answers
5k 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
0answers
33 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
0answers
6 views

Alternative DOI resolvers besides dx.doi.org?

http://dx.doi.org/ is frequently slow for me. Are there any alternative DOI resolvers? thanks
0
votes
2answers
103 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
1answer
54 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
1answer
60 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
2answers
68 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
1answer
822 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 ...
0
votes
0answers
33 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
3answers
453 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
1answer
230 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
1answer
92 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; ...
11
votes
4answers
40k 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
2answers
599 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 ...
1
vote
2answers
6k 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 ...
0
votes
2answers
65 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
1answer
2k 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 ...
4
votes
4answers
836 views

Is there any free reverse DNS lookup service (DNS replication)?

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
1answer
259 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
2answers
220 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 ...
7
votes
1answer
451 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 ...
3
votes
4answers
8k 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
2answers
155 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
2answers
1k 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
2answers
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 ...
1
vote
1answer
949 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
4answers
5k 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 ...
2
votes
2answers
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 ...