All Questions
51
questions
5
votes
1
answer
9k
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 "...
2
votes
2
answers
13k
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 ...
2
votes
2
answers
2k
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 ...
2
votes
2
answers
2k
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 ...
2
votes
2
answers
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 ...
2
votes
1
answer
69
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 ...
2
votes
2
answers
484
views
How can I get information from one cell in a row, based on the clue of 2 other cells in the same row?
I'm trying to get Excel to give me information in Column C based on the values in Columns A and B.
Cell A and Cell B will contain duplicates, and what I'm trying to do is build a formula which finds ...
1
vote
1
answer
363
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 ...
1
vote
1
answer
172
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
402
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
1
answer
101
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.
1
vote
1
answer
175
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
vote
1
answer
165
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;
...
1
vote
1
answer
89
views
Given a value, I want to find this value in one range and then report out a value in the same relative position in a different range
I have two ranges on the same sheet, we'll call them Range A and Range B. These ranges are the same size and their location on a sheet is known.
I ultimately need to find a value in Range B. To start ...
1
vote
0
answers
122
views
Excel: Icon conditional formatting based on column name lookup
I am trying to create a conditional formatting rule for a table which looks up a pass mark in another table and then compares the value to that pass mark. It is meant to be as general as possible ...