Questions tagged [lookup]
141 questions
18
votes
5 answers
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?
Bart van Heukelom
- 2,137
17
votes
7 answers
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 equally useful.)
The reason is that I have two text…
Torben Gundtofte-Bruun
- 18,646
9
votes
1 answer
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 done it before, but forgot for the moment.
Correcting…
hossayni
- 567
9
votes
1 answer
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 with, but I have no idea if there is a general…
jerryjvl
- 2,535
5
votes
1 answer
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 of highlighting these near-duplicates
Tim
- 53
5
votes
1 answer
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 "parent directories".
Currently I have an index which…
Alex
- 53
5
votes
1 answer
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 UP which is useless and I have to do this second…
Levchik
- 153
4
votes
4 answers
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 ... share". At the beginning I hadn't netbios…
register
- 163
4
votes
4 answers
Lookup over matrix with non-numerical data
I have several minitables (title, content) organized in a matrix, like the following example:
I want to do a lookup such that I put the "title" value in a cell, and return the content. So, I put a letter in yellow cell and return the content, as in…
luchonacho
- 189
3
votes
3 answers
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 exe lookup?
ripper234
- 11,903
3
votes
4 answers
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 aggregate data I usually use sumif, vlookup/hlookup…
Ruut
- 427
3
votes
1 answer
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 then I want a text description to be filled out…
3
votes
3 answers
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 docs spreadsheet. I have office 07. Thanks for any…
Troy
- 31
3
votes
4 answers
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 the important dates column, it is…
Kent Boogaart
- 489
3
votes
2 answers
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 (it's between 11:24 and 12:55) I want to get in the…
Dani
- 753