if-statementgoogle-sheetsgoogle-sheets-formulaarray-formulasgs-vlookup
Google Sheets VLOOKUP using arrayformula not working
I am trying to populate rows of data from another sheet using VLOOKUP and ARRAYFORMULA.
Here is the data where I am using arrayformula:
G2 has the formula:
=arrayformula(if(ISBLANK(E2:E),"",VLOOKUP(E2:E,'Product List'!$A$2:$C,2)*F2:F))
And here is the "Product List" from the other sheet:
As you can see, it is bringing in the wrong numbers:
What is wrong with my arrayformula that is making it do this?
Solution
If the content in column E is not an exact match to something in column A, it will pull the closest match. If you don't want this, you can fix this by adding FALSE as the fourth parameter in VLOOKUP. By adding FALSE as shown below, cells that are not a match will show as #N/A instead of an incorrect number.
=ARRAYFORMULA(IF(ISBLANK(E2:E),"",VLOOKUP(E2:E,'Product List'!$A$2:$C,2,FALSE)*F2:F))
Other than that, I don't see why the formula wouldn't work.
- Mysql How to only select from a column if the column exists
- Unable to use IF statement in plpgsql
- Adding only some data labels and a total value at the top of my stacked bar chart
- Good C-coding style for multiple lines if conditions
- If statement to check if an array is not in another array
- Determining if a string contains a word
- How can I make a def function with my "if" statements?
- How to assign a variable in an IF condition, and then return it?
- Using or in if statement (Python)
- C# Creating a Square
- Return TRUE/FALSE column for checking if a set of columns contains a value/string
- Does Go have "if x in" construct similar to Python?
- Does if (myBool == true) differ computational wise to if(myBool)?
- Write a Basic Car rental program on java / problems
- Writing a "Chessboard" function in Python that prints out requested length of binary
- Will my program execute "else" even if it executed my "if"?
- Why Java does not see that Integers are equal?
- How to have the Xcode 3.1 compiler warn of assignment operator in an if statement?
- Nested if Statement good or bad?
- How to write if statement in .tmux.conf to set different options for different tmux versions?
- is not null Vs != null (Unity C#)
- VBA "does not equal" code not stepping through IF statement as expected
- Avoiding nested if else statement ladder in Python
- I want to take output from a function to use in a IF statement in another function
- What actually happens when we put conditions without [] (brackets) in if else block in a bash script?
- C++ The if statement is still true even when only one condition is met
- Fortran if statement errors
- How can I change certain values in a column based on multiple conditions, leaving others as they are if the conditions aren't met?
- If statements to process a specific numeric value of a variable always fall into the last if statement no matter the value of the variable
- If formula (the sum is less than 30 then roundup tp 30)