if-statementexcel-formulaconditional-statementsreturn-value
Match two columns and return values based on a condition in two other columns
Four total columns: Column A Part#, Column B Old Cost, Column C Part#, Column D New Cost
I need to match the two Part# columns (they are the same part numbers in a different order):
Once matched, compare the accompanying two columns of Costs
If the costs match, return MATCHED
If the costs are different, return the New Cost amount
Col A Part# Col B Old Price Col C Part # Col D New Price**
5555 $5.00 1111 $1.00
4444 $4.00 2222 $2.99
1111 $1.00 3333 $3.00
2222 $2.00 4444 $4.99
3333 $3.00 5555 $5.99
8888 $8.00 6666 $6.99
7777 $7.00 7777 $7.99
9999 $9.00 8888 $8.99
6666 $6.00 9999 $9.99
An example return:
Part# 1111 MATCH
Part# 2222 $2.99
Part# 7777 $7.99
Part# 3333 MATCH
Solution
Use VLOOKUP and compare the results:
=IF(VLOOKUP(G2,A:B,2,FALSE)=VLOOKUP(G2,C:D,2,FALSE),"MATCH",VLOOKUP(G2,C:D,2,FALSE))
- An "and" operator for an "if" statement in Bash
- Checking for character in a string
- VB6 and VB.net has different outcomes with the same IF statements
- Returning Values to Razor Page - Confused Javascript or .cs?
- Excel VBA - how do I get the RowSource of a ComboBox to change depending on the value of another Combobox?
- comma operator in if condition
- How to assign values to a df$column from another df using conditions in R
- Else if statement to create a new column
- How can I run code If any one of if else statements is true?
- zsh condition on number results in bad pattern
- Cobol - checking for remainder in IF clause
- Can you store a variable inside a if-clause?
- How to use the @if angular with async pipe and alias for else block?
- Condition in python lists comprehensions
- nested ifelse in R with "condition has length > 1" warning
- Best practices for integrating optional arguments in shell command inside a snakemake pipeline
- Using joins and if statements
- Using Conditional Statements in Dymola
- Declaring a Variable in if-Statement
- Oracle sql return true if exists question
- How do I replace words in an HTML page using JS?
- How to automate a series of similar IF statements
- How to check a pattern in a string in matlab?
- If statement isn't showing console.log when condition passed and continue work as unexpected
- Order of Conditions in `if ... else if ... else ...` in C++
- How can I assign NA?
- How to return in an Async Function in Angular?
- Why does python use 'else' after for and while loops?
- Calculating my tax automatically in Excel
- Conditional If Statement: If value in row contains string ... set another column equal to string