Return a 3rd column when 2 other columns match

debugcn Published at Dev

Molson1020

I am trying to return the data of a third column when two columns match. For instance, column 1 would be "First Name" and column 2 would be "Last Name" with column 3 being their favorite color. I tried the following as an array with no success:

{=if(and($A$1:$A$50=D2,$B$1:$B$50=E2),$C$1:$C$50,"")}

I only need the first time that column A and column B match. Ultimately, this is like Vlookup with 2 variables.

D2 and E2 are the names to match.

Can this be done?

Domenic

Try the following formula, which needs to be confirmed with CONTROL+SHIFT+ENTER...

=INDEX($C$1:$C$50,MATCH(1,IF($A$1:$A$50=D2,IF($B$1:$B$50=E2,1)),0))

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-08-13

Comments

0 comments

From Java

Group by 2 columns with calculation of quantile of 3rd numerical column

From Dev

Pandas groupby 2 columns, select max of 3rd column

From Dev

Match Vector to multiple columns, return index and corresponding value in other column

From Dev

bash - merging 2 files using 2 common columns and add up the values of the 3rd column

From Dev

Calculate average of a column when two other columns values match

From Dev

Match first and last name to 2nd column then output corresponding 3rd value

From Dev

How best to sum 2 columns and update 3rd column with sum?

From Dev

Using MySQL to calculate difference of 2 columns to equal a 3rd column

From Dev

comparing values of 2 columns from same pandas dataframe & returning value of 3rd column based on comparison

From Dev

Creating a button which matches 2 columns and put a value in 3rd column

From Dev

oracle sql query finding rows with multiple values in 3rd column matching columns 1 and 2

From Dev

How to create a 3rd column based on 2 columns from two tables [inner and outer join]

From Dev

awk compare 2 files, print match and nonmatch lines;3rd column of first file and 2nd column of second file

From Dev

How can I add strings on the first 2 columns and add buttons on the 3rd column for each rows of strings in pyqt tablewidget?

From Dev

Select an ID from a column when comparing 2 other columns in SQL

From Dev

Minimum column value if two other columns match

From Dev

Efficient grouping by 2 columns as a percentage of 3rd

From Dev

MySQL: select max combination of 2 columns and distinct 3rd

From Dev

Calculate the duration in the same column between 2 rows that they are match to each other in another 2 columns using python?

From Dev

pandas dataframe: return column that is a compression of other columns

From Dev

Match two columns when one column has fewer entries than the other in Excel

From Dev

VBA Set Columns equal to each other if other column values match

From Dev

VBA Set Columns equal to each other if other column values match

From Dev

SQL query to get table rows whose columns should not match with other table columns when passing same column id

From Dev

Read 3rd and 4rd column and append to 2nd column

From Java

How do I query for all rows but limit by max values of two columns when 3rd column is of a specific value in one single query?

From Dev

How do i use a lookup in excel to return a value from a third column, if criteria are met in 2 other columns

From Dev

Excel match 2 columns get return value

From Dev

LINQ-to-MongoDB - Return list only when values between 2 columns match

Related Related

Article