All Questions
51
questions
1
vote
1
answer
5k
views
VLOOKUP and HLOOKUP combo
I am struggling with the following (see snapshot) and I can't understand what I'm missing.
If the id matches, I would like to extract the value of that id in when the values in col2 matches the ...
CommunityBot
- 1
0
votes
1
answer
100
views
How to convert a simple VLOOKUP to XLOOKUP in Excel?
The VLOOKUP works as intended. The XLOOKUP is giving "#NAME" error:
screenshot of the formula:
the working VLOOKUP:
=VLOOKUP(C12,B24:C29,2,FALSE)
Which I'm reading as "take the ...
- 2,593
-1
votes
1
answer
24
views
how to use SUMIF to calculate a cell from the figures in 2 other cells based on the date
I have one cell that calculates a figure based on 2 cells, so for example target quantity is in C6 then the completed quantity is in D6 so cell E6 is "=D6-C6" but i only want it to ...
- 2,320
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 ...
- 8,931
0
votes
3
answers
77
views
What formula should I use to pull
What Excel formula can I write so it will look for the same project in Column B in Column I and place the YTD matching the project from Column J in Column C in the table below?
A B ...
- 2,593
0
votes
1
answer
470
views
How two-way lookup works in excel?
The two-way table is a table where the value of a dependent variable is dependent on two independent variables, so actually it's a mix of two one-way tables.
When you lookup for a value in a two-way ...
- 429
0
votes
1
answer
2k
views
How to return first non-blank value with LOOKUP function
I have a table:
table in which I reference data from a dataset using a LOOKUP function. I can reference columns(such as new_deaths) which have the latest(non-blank) data just fine. However, for some ...
- 1
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 ...
- 157
0
votes
2
answers
122
views
Why does this LOOKUP function work like this?
Can you please help me understand why this LOOKUP function works as it does? The formula in yellow-highlighted cell A6 seems to return the label (from row 2) above the rightmost non-zero data value (...
- 427
0
votes
2
answers
2k
views
#NAME? Excel error only occurring on one computer
We are using Excel 365. I was teaching my colleague XLOOKUP yesterday but she kept getting #NAME?.
What she entered was correct. She redid it in a new column in case any odd formatting was causing ...
- 28.4k
1
vote
1
answer
161
views
Need to lookup values in row and give the corresponding month in the column
I need a formula that looks up the number of sales in a month and stage and gives you the highlighted cells in the columns. It has to count the first cell that the sales start in and then if you have ...
- 3,134
0
votes
3
answers
2k
views
excel formula to look at only 10 digits of the cells
I want to look at only the first 10 digits of the cells.
If the cells that are in column C equals to the cells in column G (but in another tab), then I want the result from column H(from same tab of G)...
- 74
0
votes
1
answer
175
views
Excel lookup returning multiple values in a column
Everyone -
I have seen numerous posts on this site similar to this, however with the way the data is laid out, none will work for what we are trying to accomplish.
I have a spreadsheet with columns ...
- 8,931
0
votes
1
answer
50
views
Look for Date values in embedded in strings
I have a value in a cell that might have a 2-digit month and 2-digit year value embedded in it, and I need a function that would return TRUE if that is found.
Sample input data: sCa!1220LB6qHZbCnsEE ...
- 23.4k
0
votes
0
answers
696
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, ...
