All Questions
201
questions
0
votes
0
answers
37
views
User with blank detail in output
As per the attached screenshot, I need a formula to derive user with a blank cell to be shown as pending. (Pending has been manually entered.)
- 43.2k
0
votes
2
answers
7k
views
return yes or no based on cell data from another sheet
I have two sheets.
The first sheet "Example A" and the second sheet "Example B".
Example A has a master sheet of clients that may also be on Example B. If the client is listed on ...
- 43.2k
0
votes
1
answer
3k
views
Need to extract multiple matches from a list of values
I am trying to extract data from a worksheet using an array formula but it will only return one (the first it finds) value. The formula I am using is:
=INDEX($C$2:$C$8, SMALL(IF($B12=$B$2:$B$8, ROW($...
CommunityBot
- 1
0
votes
1
answer
62
views
XLOOKUP - I need the lookup value to default to 2 decimal places
I currently have a spreadsheet that i want an occurance ratio, the lookup value is giving me 9 decimal places, how can i change it to 2 so i don't have a million lines with the lookup values?
Example: ...
- 1,000
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
0
answers
36
views
Excel - Formula help - If A2 = !A2:A4, highlight !B2:B4 IFNOT = B2
I have 2 large workbooks of employee data and need to express the following in a formula.
Workbook 1:
Employee ID
First Name
00000001
Sam
00000002
Fred
00000003
Bob
Workbook 2:
Employee ID
First ...
0
votes
1
answer
41
views
Excel lookup/match bug - can find given but not calculated value, even if they're the same
I'm experiencing a very odd behaviour with Excel lookups and match: if I try a lookup or match for 7.03, it will find a cell, but if I lookup 7.02+0.01, it fails. For example:
A
B
1
7.01
a
2
7.02
b
...
- 2,320
0
votes
1
answer
230
views
Excel - Vlookup within Vlookup dependent on drop-down
Please bear with my explanation here - I want to be as clear as possible. I have about 8 different tables (different categories), which contain ranges that correspond to point values. I have been ...
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,603
0
votes
1
answer
63
views
How to get an exact match with VLOOKUP into the current cell
The name "Dodson" is on A5, the lookup is from B5, the table A16:B19, the value in the second column of the table, but am looking for the precise result of a VLOOKUP.
The formula I have is:
=...
- 23k
0
votes
0
answers
53
views
Excel Vlookup Where Column to Search is identified in Preceding column
I am trying to figure out if there is a way to write a formula such that the Table_Array of a vLookup is based on a value from another column. Basically, I want the Vlookup to search on another sheet ...
- 2,603
0
votes
2
answers
45
views
VLOOKUP displaying wrong information in Excel
new to excel, and trying to do a simple task, where depending on the months in a month range, some percentage will be displayed. However, it's always displaying 0.
Here's a picture to help you ...
- 2,603
0
votes
1
answer
101
views
Using a ~ tilde in a Vlookup excel formula
How would I use a Vlookup with multiple tildes in the text string? It would look something like this:
SWBC ~ 7797_Dodge_Challenger ~ Video ~ New
What would the VLookup formula be?
- 8,457
0
votes
1
answer
296
views
How to Autoincrement the Column index number by dragging VLOOKUP formula down
I need to drag a Vlookup down and have the Column index number in to increase by 1 every row I drag it down.
So for example:
Row 1:
IF(VLOOKUP(A2,'Jan 2024'!$D:$BP,**35**,0)<=0,"IGNORE",...
- 18.3k
1
vote
3
answers
324
views
VLOOKUP where part of lookup-cell can be contained in lookup table
Most of the time, I use wildcards in VLOOKUP to get a match when my lookup table contains longer descriptions of which a part might match my lookup value.
I now have the opposite usecase; I have a ...
- 5,470