# Questions tagged [lookup]

The lookup tag has no usage guidance.

**0**

votes

**0**answers

30 views

### How do I match a specific word in a cell with that word in an array?

The first column is for the ITEM TITLES of random items and the third and fourth columns are for the CATEGORY ID and CATEGORY NAMES, respectively, that the item could fit into. The second column, ITEM ...

**1**

vote

**1**answer

53 views

### Returning the column header when the progressive difference of values in a row becomes <= 0

I have an Excel table with the initial stock for an item and the projected consumption based on the corresponding dates in the header. I would like to retrieve the date when there is going to be a ...

**0**

votes

**1**answer

13 views

### How to lookup for NA value in Excel?

I have two sheets:
Contains form number and amount
Contains bill number and amount
I tried to reconcile which bill belongs to which form using simple lookup based on the amount, ignoring duplicate ...

**1**

vote

**0**answers

40 views

### MAX Result of multpiple results from INDEX and MATCH

I am working with 3 columns, fname, lname, & date. Where there will be multiple duplicates of fname and lname. I am trying to write an INDEX & MATCH that will display the MAX result or the ...

**1**

vote

**2**answers

276 views

### Finding the next higher value in a column

I have two columns, A and B. Column B has values which I need to look up in Column A. However, I don't need to find the exact corresponding value, I need the next higher value.
For example:
Column A ...

**0**

votes

**2**answers

57 views

### Lookup Function Giving Inconsistent Results in Excel & Google Spreadsheet

I am trying to create a column of looked-up values using the LOOKUP function. The goal is for the formula to look up the "rank" value of each "name" and print it in the "lookup" cell on the same row.
...

**1**

vote

**1**answer

76 views

### Allow a cell containing multiple delimited lookup source values to also contain non-lookup values

Lookup multiple values in a different table given a cell containing multiple delimited values
Please open the link to see the previously answered question.
Given that context, is there a formula ...

**1**

vote

**1**answer

127 views

### Lookup multiple values in a different table given a cell containing multiple delimited values

I have two tables, which look like this:
I would like Excel to use the value in ID company associated in table 2 (green), look for it in table 1 (orange) and return the value from Company name, or ...

**0**

votes

**0**answers

7 views

### Lookup that returns cell data with the formatting

When using lookup the returned data is in the plain text, however, the data in the cell that has been looked up is a hyperlink. I would like the hyperlink to come through with the lookup as well so as ...

**0**

votes

**1**answer

175 views

### Need formula to calculate tiered commissions, according to percentages

First off, I have looked everywhere, and every solution assumes that I'm working with dollar amounts, but my client works with percentages. That being said, I need to figure out the formula to ...

**0**

votes

**2**answers

222 views

### Find value in a non-continuous range in Excel

Is there a way in Excel to look for a numeric value in a non-continuous range throughout the table?
Please refer to the image below:
I need to search for the value 2 between the range minimum value ...

**1**

vote

**1**answer

81 views

### Excel formula - creating invoices from data list

I have an Excel spreadsheet with two tabs - one tab is a list of sales data (eg. date, amount, customer name, invoice number) and the other tab is where I want to make very very simply invoices (they ...

**0**

votes

**0**answers

33 views

### Copying specific data from one sheet to another using value entered

Here is my scenario.
I have 2 sheets in a book. I enter info for 2 different businesses into the sheets and need to be able to verify the same info based on 2 criteria (hence the 2 sheets) enter image ...

**0**

votes

**1**answer

47 views

### Excel 2013 - How to have a Lookup return the first date after a specified date?

So I am looking to create a function that searches for a unique ID code in one column, and returns a corresponding time stamp from another column. However, there are multiple time stamps attached to ...

**0**

votes

**1**answer

80 views

### Lookup value within a range around a given lookup value

I have 2 databases that I am working with in Excel. They are Internet speed tests which separate the user entered address and the actual speed-test into 2 databases. The address table and the speed-...

**1**

vote

**1**answer

46 views

### ssh - looking up IP through API on-demand

Is there a way to make ssh dynamically lookup the ip address for a given hostname through an external API?
The scenario is that I have a few customers with thousands of varying on-demand cloud ...

**0**

votes

**2**answers

46 views

### Simple lookup does not return correct values

I have a very simple situation:
Column I Column J
S 0
M 1
X 2
XL 3
I would need the lookup to return number based on the size, which is entered in the cell D6:
=...

**2**

votes

**3**answers

332 views

### Excel: Multiple column lookup and count

I'm sorry but I don't know how to google this. I have a table that looks like this:
response|item| categoryA| categoryB
----------------------------------------------
Yes item1 ...

**-2**

votes

**1**answer

55 views

### Excel - Need help in VLOOKUP function

I am an Excel beginner. Could anyone help me?
I am quite confused with this lookup function. Why is cell C6 the lookup value while D6+1 is the lookup row? When I tried to use D6 as lookup value and ...

**0**

votes

**1**answer

47 views

### Excel lookup / compare values

I need some help to sort out an old, bulky, crappy file.
So here is my problem.
I have an excel file like this:
and i need to sort it like this:
Keep in mind that the food type changes for each ...

**0**

votes

**1**answer

35 views

### Lookup & Populate Item Matching 2 Criterias

I have a sheet of transactions categorized as either income or expenses. I would like to populate expenses which are more than a certain value, say, more than $5,000, as a list in another sheet. I ...

**0**

votes

**2**answers

134 views

### LOOKUP not working for a simple example in Excel. What am I doing wrong?

I have a list of scores. I want to convert them to a new score based on a table I have. I am tried using lookup and vlookup and I can't get it to work. What I am doing wrong?
Here is a link to the ...

**0**

votes

**0**answers

22 views

### Payments Lookup EXCEL - What function to insert when blank if it changes by week

In excel, I need to show on a "summary" tab the payments that should be made Friday by Friday. I have this information on another tab, where you can find a list of names of whom we should pay and ...

**0**

votes

**1**answer

392 views

### Open Office Calc lookup vlookup

I am trying to return a value to a cell, columns C to H depending on what is chosen in the drop down in column B.
The figures I need to return are held on a separate sheet .
Any help with this would ...

**0**

votes

**1**answer

72 views

### Excel: For A1, find the highest subsequent cell before a cell of <A1 is found

I have column of fluctuating prices over time in column A, lets say the price of a particular stock for arguments sake.
In column B I want to know how high the price went, from that point, before it ...

**2**

votes

**2**answers

563 views

### HLOOKUP: gives inaccurate data depending on the formula for lookup value

I ran into this weird problem while trying to work with the HLOOKUP function. I've built a simple case here to demonstrate.
In the column starting in C7, I will enter the hlookup functions (shown in ...

**1**

vote

**1**answer

77 views

### Excel Search for a Term, Return the corresponding terms in the array

A Spreadsheet has 5 columns and 600 rows. In column 1 (by way of example) there are 9 types of virus', all of which are mixed but all consistent in spelling. The other 4 columns are characteristics ...

**0**

votes

**1**answer

63 views

### How to sum horizontal cells based on the value of the cell to their right in Excel

I'm trying to summarize monthly "hours worked" data. Each row is formatted as this example. This example is one week for two employees
Louie, 8, solar, 9, service, 8, solar, 8, solar, 7, service
...

**2**

votes

**0**answers

13 views

### Mac OSX Excel 2016

I have a list of invoice lines. Each invoice line has a supply number and this can be repeated as many times as there are invoices. Each line has a from and end date for the supply and a consumption ...

**1**

vote

**1**answer

26 views

### How to retrieve a value from row of data

I have a list of values in row in sheet1 (say A1:K1), from this row of data list, I want to search for a value in N1 in sheet2, and if it is present in the row, then put the value in N5. (if the vaue ...

**-6**

votes

**1**answer

104 views

### “super advanced” excel, EXPERT NEEDED

I am trying to write a formula for cell J8 that returns the money value by looking up all the rest of information in column J. For clarity, I want a formula in J8 that takes the 3 values above it to ...

**0**

votes

**2**answers

393 views

### Fix entire column in a formula in Excel

I want to fix a lookup value so that it does not change the formula when I copy it. For example:
=LOOKUP(B1,A:A,J:J)
Here, I don't want A:A or J:J to change when drag copying or copying.
How can I ...

**1**

vote

**1**answer

1k views

### Excel - How to remove similar cells within the same column?

I have a problem on Excel 2010.
I have a column which lists the names of manufacturers', like so:
Manufacturer
Company 1 Ltd
Company 2 Ltd
Company 3 Ltd
My problem is when there's a spelling ...

**3**

votes

**1**answer

63 views

### libreoffice calc - find value in subtable

Let's say I have a sheet and somewhere on it a table like
AAAA 8 16 32 48 64
50 x08050 x16050 x32050 x48050 x64050
150 x08150 x16150 x32150 x48150 x64150
250 x08250 ...

**1**

vote

**0**answers

187 views

### OpenWRT slow Lookup / DNS? (TP-Link WDR4300)

On my TP-Link WDR4300 I had OpenWRT Chaos Calmer 15.05 running. After moving to another house I noticed that establishing connections is taking way longer than before, e.g., +5 seconds to find google....

**2**

votes

**2**answers

148 views

### Lookup a number in a collection of ranges in Excel

As in the example below, I have a table containing a collection of ranges.
Each range has an associated description. I want to look up the description for a number that falls within one of the ...

**1**

vote

**0**answers

691 views

### FAST VBA based vlookup equivalent

Trying to copy the function of vlookup in VBA, the best I can come up with is this:
Function VBALOOKUP(LUcell As Variant, LUArray As Range, LUColi As Long, OutColi As Long) As Variant
Dim Y() As ...

**0**

votes

**1**answer

63 views

### Excel get value between 2 dates

I'm attempting to retrieve a value from a table with set dates
For example, given the table below, if a user entered the date 01/07/2019 it would retrieve D or 4. If a user entered 01/07/2017then it ...

**1**

vote

**1**answer

4k views

### What is responsible mail addr record?

I've been searching in google but I couldn't find documentation about it. E.g, using "nslookup" for look into soa registry of google.es you can see how responsible mail addr has the value of "dns-...

**1**

vote

**1**answer

68 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

311 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

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

**3**

votes

**1**answer

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

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

**3**

votes

**1**answer

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

**1**

vote

**1**answer

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

**-1**

votes

**1**answer

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

**4**

votes

**1**answer

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

**0**

votes

**1**answer

40 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 want ...

**0**

votes

**3**answers

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