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.)
- 1
0
votes
1
answer
155
views
Function to search for specific number and then to further search for the suffix
I have a huge amount of data to process in which 4 points with a related prefix needs to be subtracted from each other.
Example on the picture attached.
(let's call prefix a "ring number" ...
0
votes
1
answer
2k
views
Excel column: If cell value is 0 replace with value from cell to the left
I am an excel novice. I have started working with data strings of over 1000 rows. Some cells in a column have 0 values and must be replaced with the value of the cell to the left. Currently, I copy ...
- 1
0
votes
2
answers
162
views
Searching by Clicking a Cell
is there a function or some way to have excel return a result by clicking on a cell?
for example, if I have a list of groceries going down column B2:B10 and the isle they are located in going down C2:...
0
votes
2
answers
171
views
Return Closest Known Coordinate When Entering a New Coordinate - Excel
I have a sheet of known coordinates laid out as Col A - Point Number, Col B - X Value, Col C - Y Value, Col D - Z Value; see below image (a lot more rows in reality).
I am looking for a way of ...
- 1
0
votes
0
answers
69
views
In excel, how do I return values beside a searched string
I am currently trying to lookup a string value in a range and have it return the value from the cell above or below it. I have tried many formulas to no avail.=INDEX(B2:J49,MATCH($V$1,B2:J49,0)-1,1) ...
0
votes
2
answers
82
views
Lookup a specific rowvalue when the column depends on another cell (row/column combination)
I have an excel sheet with a very large, scarcely populated matrix.
The first column describes an item, and the columns after that whether an item belongs to a certain group. Each item can only belong ...
- 101
1
vote
1
answer
38
views
Vlookup search Bug
When I use VLookup to auto fill rows from a chart, it works for every search value except searches where the lookup value is CPT-X. In this scenario original formula:
If I change the lookup value to &...
- 11
1
vote
1
answer
197
views
VLOOKUP logic when range_lookup is TRUE but table_array is not sorted
Excel's VLOOKUP hint tells us to use range_lookup = TRUE only when the table_array is sorted. However, does anyone know what is the logic that VLOOKUP executes when range_lookup = TRUE but table_array ...
- 111
0
votes
2
answers
1k
views
Excel wildcards not finding the matches they should in VLOOKUP function
I have multiple product families I'm working with, and each family has multiple products within. Some families have more products than others, all product names are unique. On one sheet named "...
- 15
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 ...
- 111
1
vote
2
answers
90
views
VLOOKUP confusion
My formula in C2 = =VLOOKUP(LEFT($A$2,3) & RIGHT($B$2,1),A9:C10,3,FALSE)
I need to join the left three characters from A2, the last character from B2 and use this in vlookup.
Can someone please ...
- 127
0
votes
2
answers
62
views
VLOOKUP Values not corresponding
I have an excel file that contains Olympic Data for 2008, 2012 & 2016. I would like to lookup the event of my dataset in sheet 1 to the table array in VLOOKUP sheet to determine whether the event ...
- 7
0
votes
2
answers
269
views
From an Excel list of event attendees spanning 10 years, how do I create another list that pulls the first year of attendance for all my attendees?
I have a list of guests that come to my events. The list contains 10 years worth of guest check-ins in order by date (ascending). Based on this list, I want to create another list that shows the year ...
- 1
0
votes
1
answer
2k
views
File name on the basis of cell value in vlookup
Currently, I am using vlookup as per the below:
This is in Cell M3 of main book:
=VLOOKUP(L3,'C:\Users\vp\Desktop\xcl\day_data\[5460993.csv]5460993'!$A:$C,3,0)
The value in Cell Z3 of the main book ...
- 21