# Questions tagged [lookup]

The lookup tag has no usage guidance.

109
questions

**0**

votes

**0**answers

36 views

### Memory Exception on Excel Fuzzy Lookup Add In

I have two tables of data with 5 columns - Name, Phone Number, Email Address, Post Code and Order Time. Both tables have around 10,000 rows. I need there to be an exact match on Name, Phone Number, ...

**1**

vote

**1**answer

62 views

### Excel lookup by minimum value

I have this table:
.
Is it possible to look up the letter grade by the minimum percent value?
For example, anything greater than or equal to 87% but less than 90% returns B+.

**1**

vote

**1**answer

30 views

### Excel - How do I look up multiple cells from a single reference?

I'm looking to somehow look up a certain amount of cells from a single reference and return them in the same order in another workbook.
For example, say I have 5 different SKU codes (these aren't ...

**0**

votes

**0**answers

8 views

### How to refer to a variable row from another sheet

I am looking for a formula to refer to an entire variable row from another sheet.
Sheet 1 is a list of truck numbers with the dates of the their last work.
Sheet 2 is pulling data from another sheet ...

**0**

votes

**1**answer

49 views

### Finding a Row Number based upon a value within a known column?

I have a workbook that's set out in a fairly specific way when imported. And I'm one lookup away from having them quickly and easily sort itself out into a more readable form.
However, without using ...

**0**

votes

**1**answer

28 views

### Take the header of most-left value in excel

I'm using the formula from this post to take the most left value from my excel sheet.
I’m using this formula for column “N” as shown at this excel print screen.
Now I have to find the most left value,...

**1**

vote

**1**answer

31 views

### Dynamic Array lookup

The values in E should match the values in D but don't. Am I using lookup wrong?
This is just a test from a larger problem I'm having. I decided to make a testbed to figure out how to use LOOKUP. My ...

**0**

votes

**1**answer

60 views

### Match 5 closest in same array

I have a list of customers and lat/long coordinates (3 columns:c,u,v respectively) I want to create 5 columns to resolve as the closest 5 customers.
So far I’m using
min(sqrt(([lat1]-[lat_array])^2+...

**0**

votes

**0**answers

21 views

### Excel - Need to get info from multiple resizing tables - Match, Indirect, VLookup

I am trying to make it so that my operators can cut and paste information into a spreadsheet and then I will have a Vlookup, etc. to be able to get the information I need. The problem is that I have ...

**-1**

votes

**1**answer

20 views

### Too many arguments in use if and lookup functions

I am using an IF formula with LOOKUP in order to evaluate and return a value in a table. For example, to return a value in a salary matrix,
=IF(K5>10,G5+SMI!$G$25,IF(I5=1,LOOKUP(K5,SMI!$F$10:SMI!$...

**2**

votes

**2**answers

105 views

### Lookup Range based on multiple column and row critera

I have the lookup table below, where columns C through E are different places:
Below, I am trying to lookup the value based on the columnar and row criteria:
How can I find the value Orange, 2019, ...

**1**

vote

**0**answers

24 views

### How to search for and return all records between two dates?

I'm not sure if this is a lookup formula I need. Basically, I have a huge spreadsheet with the travel details of lots and lots of groups. Each row is a different group. For reference, Column K shows ...

**0**

votes

**2**answers

52 views

### Using AVERAGEIF() over a range of years

I have a dataset that includes year, country, and population data. A small condensed sample is below.
I am trying to write an excel statement that would calculate the average population from 1980 - ...

**1**

vote

**1**answer

36 views

### Excel: Use Cell in Formula Based On Criteria

I have the following Excel workbook sheets.
SHEET 1 contains data on criminal sentences handed down for specific individuals:
| Name | DateOfBirth | DateOfSentence | SentenceYears |
|------|---------...

**0**

votes

**0**answers

91 views

### Pentaho Data Integration: Table Lookup Step throws “Cursor has been closed.”

I am having some difficulties with a table lookup Step in PDI that gets data from a Filemaker 16 database.
First problem was that suddenly PDI (Kettle) did freeze when I opened the step. This was ...

**0**

votes

**1**answer

312 views

### Calculate weighted scores via column heading lookup in Excel

I have a data entry sheet with multiple columns, and the user is allowed to input a number in each cell.
I have a separate table with a weighting based on each Column's heading.
The desired output I ...

**0**

votes

**2**answers

35 views

### LOOKUP reference with mulitple outcome values

I am looking to pull out and display the multiple ages of people associated with a single reference number.
Below snipped displays the sheet set up. The sheet has approximate 2500 rows:
App ref,...

**0**

votes

**1**answer

37 views

### Assitance with Lookup function for matching two sheets of data

Basically I have two sheets (s1 and s2), and the data is formatted something like below, first is S1:
ID Name
1 Prod 1
2 Prod 2
3 Prod 3
4 Prod 4
5 Prod 5
6 Prod 6
...

**0**

votes

**2**answers

83 views

### Exclude IPs from IP list that are from Russia

Which command in Bash should I use to exclude all IPs that are from Russia from an IP list?
I had in mind maybe with the help of geoiplookup. What I would really like to have as result;
original-IP-...

**1**

vote

**0**answers

479 views

### Microsoft Excel Fuzzy Lookup add-on - set too big?

The data I'm comparing is a set of cataloged items (90k items) with an old list of items we thought were missing (about 11k). I need to see if any of the "missing" items actually show up in the ...

**1**

vote

**1**answer

37 views

### Values in a column to rows based on multiple criteria

I am trying to turn a the table on the left side to the one on the right.
How can it be achieved? I have tried This, but it did not work.

**0**

votes

**1**answer

30 views

### Row data distributed into multiple rows on a separate sheet

I have a fuel consumption log, with vehicle id's in column 'C' and fuel consumed and distance traveled for different dates as the headers.
example
I have made multiple sheets based on the vehicle id'...

**0**

votes

**0**answers

69 views

### Excel HLOOKUP to reference multiple Cells as “lookup_value”

In this file:
https://drive.google.com/open?id=1rwPyt7RKLCVIMWEuAxdl3H3vYxXtUX8S
Cell A3 on the first sheet "Import Template" has this formula:
=IFERROR(IF(HLOOKUP(A$2,Sheet1!$A:$ZZ,ROW(A2),FALSE)="...

**0**

votes

**2**answers

963 views

### Map/Copy values from one sheet to another in excel if they match on column header

This post gets me very very close to where I need to be
How can I copy a column from one sheet to another sheet based on title in Excel?
However if I add an =if(isblank(Sheet1!A2),"",... to the ...

**1**

vote

**1**answer

58 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

20 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

50 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

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

345 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

144 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

221 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

**1**answer

672 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

891 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

195 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

35 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

57 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

101 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

56 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

708 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

450 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

67 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

55 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

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

**1**

vote

**2**answers

341 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

24 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

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

76 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

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

83 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

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