All Questions
116
questions
0
votes
0
answers
11
views
In Excel, I use a dropdown list which populates cells. I have enabled multiple select in the ddlist, but now the cells do not populate?
I have a dropdown list on excel. When an item is selected it prepopulates cells using VLOOKUP from the table/dropdown list. Now I have modified the VBA to enable multiple selection in the dropdown ...
- 1
0
votes
1
answer
69
views
Customised XLOOKUP formula
I am trying to Automate an Sheet with an customized xlookup. I am able to figure it out 80% but stuck with the last step. Can any one help?
I have this Formula which I am trying to build using the ...
- 1
0
votes
2
answers
58
views
Issue writing vlookup for filling values based on filter for data over a table
I am unable to create a proper VLOOKUP to fill B8, B9, B10 in the image attached. which are derived from the table A12:G15, based on filter value selected in B1. could you help with a proper VLOOKUP ...
-1
votes
1
answer
104
views
Comparing similar words in two different columns
I have list of different categories in same dataset in two different columns.
Example data how the comparison should be:
There are some similar words in the two columns. So by comparing the two ...
- 117
0
votes
1
answer
335
views
vlookup error when lookup value cell has been populated with formula
I have the following formula which is producing a #N/A error:
=VLOOKUP(N8,Lookups!J5:L2772,3,FALSE)
The formula in N8 is:
=LEFT(M8,4)
And the value in N8 will be the first part of a UK postcode (e.g....
- 55
0
votes
1
answer
54
views
I need to change one value to the next down a list (up to n amount) if said cell becomes blank
I currently am writing an excel formula for identifying different values with a common cost center, however, I need this formula to be able to go down a list of different cost centers and once it runs ...
0
votes
1
answer
1k
views
Excel Combining Countif and Vlookup
Table 1 (input):
Name
Value
Bob
0.5
John
1.2
Bob
0.3
John
0.1
Jane
3
Table 2 (expected output):
Name
>=0 & <1 Count
Bob
2
John
1
Jane
0
I'm looking to count the names in Table2 (...
- 119
-3
votes
2
answers
73
views
Excel/Google Sheets - find matches if in 4 columns
I have 1 sheet with 4 columns (A,B,C,D), with each containing a list of emails.
I would like a way to create a new column of emails if they were found in all 4 of columns A-D.
Does anyone know of a ...
- 3
0
votes
0
answers
26
views
How to apply vlookups to a range of cells dynamically within a single cell?
I'm trying to sum numbers which are the result of multiple vlookups in a single cell.
Is there a way to do this dynamically? and more efficiently than I have done now?
MY current formula below is ...
- 47
0
votes
2
answers
75
views
I am looking for any easy excel dynamic formula to find the amount for each Week per person as per attached list
I have below data and I need Week wise and Name wise Amount through a dynamic formula. Any help in this regard is highly appreciated.
- 15
2
votes
1
answer
112
views
Excel matching 2 columns by text and numbers
I have 2 excel tables with data and i want from table 1 to get the item number and add it to table 2 based on item description thats contained in table 1 column itemName2.
Table1 data:
Table2 data:
...
- 103
0
votes
0
answers
147
views
how to match date range with multiple date range in excel along with ID
I have two excel sheets, I am trying to find all user details along with request IDs that are accessed on a particular date and time range.
Sheet 1: Request
A
B
C
D
E
User
Request ID
Startdate
...
0
votes
1
answer
205
views
Index Match within an index match? or Index matching from two different sheets - Excel formula
I am using an index match in the main sheet 1 to find one set of values pulling from sheet 2 but is it possible to search in sheet 3 if the value results in #NA? or is there another formula statement ...
- 13
1
vote
1
answer
52
views
How to create a formula in Excel that will search for a value in one column (external sheet) and another value in another column (same ext sheet)
I have two Excel sheets and need to see if items in one of them (smaller) are already included at the other.
Problem: columns are not the same. Some are, but not all, and indexed items are duplicated (...
3
votes
2
answers
98
views
Perform different VLOOKUPs based on value of =RIGHT value
Summary:
I am needing to =VLOOKUP different column numbers based on the outcome of a =RIGHT statement. My current formula performs this as expected, but isn't easily scalable should I need to add more ...
- 308