All Questions
3,402
questions
0
votes
0
answers
23
views
Excel - How to a calculated value from a range by ratio
Assume I have this lookup table:
Column A
Column B
60%
10
70%
9
And the value I want to match is 65%
I'm trying to find a formula that will give me the number that's in the same ratio between 9 ...
0
votes
0
answers
48
views
Entered too many arguments for this function
I am having a problem where I am unable to find out the issue with my formula in Excel. Everything worked fine until I added an additional argument to the string, but I do not see any erroneous commas ...
-2
votes
1
answer
47
views
Load data in new sheet using existing sheets in Excel using Vlookup or power query
I am working on an excel book which does have two sheets sheet1 and sheet2. This is a large data set consist of more than 20000 records. I could not get this figure out.
Sheet1 columns:
RecordID | ...
-2
votes
0
answers
47
views
what is the best excel function to solve this problem? [closed]
sentences
email
name
name
email
date
sentences1
solution1
sentences2
solution2
sentences3
solution3
you are beautiful
Jack
non@gma
01/02/2024
sen37
blabla
sen4
blabla6
sen8
balbla11
nice one
Jessy
...
-3
votes
0
answers
44
views
VLOOKUP returning me N/A even though there is a match [duplicate]
I am trying to do a VLOOKUP as shown below;
So basically it is a mapping of Code and Value and I need the Code for matched string.
=VLOOKUP(D18, F9:G14, 1, FALSE)
So I need an exact match from COL2 ...
0
votes
0
answers
32
views
When the Values From Two Tables Match Write the Value of Adjacent Column in Table 2 to Table 1 [duplicate]
I have two tables. Table 1 contains a list of names in Column A. Table 2 contains a names and codes column (Column A and B). I want to take the value from Table 1, Column A, search a range of values ...
1
vote
1
answer
48
views
VBA for Vlookup with multiple criteria
I have a worksheet where I have a mixture of manual and automated input. I am trying to write some VBA code to first check if a cell in range is blank, and only if it is, pull date from a sheet of ...
0
votes
0
answers
25
views
Error 1004: Unable to get the vlookup property of the worksheet function class:
I'm having the issue in the subject while I'm doing a vlookup, this is the code, could someone please help me:
Private Sub cradle_afterupdate()
If WorksheetFunction.CountIf(Sheet1.Range("A:A"...
0
votes
2
answers
74
views
How to Count Countries from Multiple Lists that Match a Given Region?
I want to count how many countries from several comma-separated lists match a given region
I'm working on a project where I have several comma-separated lists of countries, and I need to count how ...
1
vote
3
answers
103
views
Using Excel for VLOOKUP and WildCard Not Working
Can you please help me discover why VLOOKUP with Wildcard is not working. I have googled for hours and tried everything.
Using:
=VLOOKUP("*"& E2 &"*",$H$2:$I$3,2,0)
It ...
0
votes
1
answer
64
views
Vlookup - getting answer from month upon month data
I have created a table with a drop down option to see a salespersons performance at any given month in the year.
I have one rating cell, which changes month on month, with it being either "poor&...
1
vote
1
answer
44
views
Excel search for certain text within cell and return vlookup from a range
In Table 1 I have a column of Names in one tab (column H) and would like to bring in the Contact information (column I) based on a list (columns A and B) in a separate tab (Table 2).
Table 1 example:
...
0
votes
2
answers
101
views
How to make excel detect Products in a Bundle and deduct each of said Products in Inventory?
As shown from the picture, it doesnt deduct the SKU sale from Bundle with the sumif formula
Lets say Bundle A has Product A100, B100 and C100
I have 3 tables:
Bundle table: List out Bundles with ...
0
votes
2
answers
39
views
Make change value in cell after selecting from dropdown list work when drag to value other cells
I have a dropdown list where I can select the full name of a person and when I select a name, it should show the abbreviation in the cell.
I got this working somehow, but my problem now that I want to ...
0
votes
0
answers
25
views
Vba vlookup works only with first column
I have a form using application.vlookup method.
When I search a value from the first(“A”) column it works perfect.
But when I search a value from the “D” column I it refers D column as the first ...