Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [lookup]

The tag has no usage guidance.

0
votes
0answers
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
1answer
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
1answer
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
0answers
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
2answers
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
2answers
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
1answer
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
1answer
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
0answers
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
1answer
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
2answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
2answers
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
3answers
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
1answer
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
1answer
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
1answer
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
2answers
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
0answers
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
0answers
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
2answers
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
3answers
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 ...