CODEWITHSUNDEEP
excelexcel-formulavlookupindex-match
Grayson
Grayson

Reputation: 29

Match two values in one sheet with two values in another sheet

The goal is to find the matching entries

Returning the matching value from the two sheets in column E in sheet1

Sheet 1 has additional add-ins
Sheet 2 stays constant

=IFERROR(INDEX($D3:D8,MATCH(SHEET2!$A3,SHEET1!$A3:A8,0)),"Additional Value")

Upvotes: 0

Views: 889

Answers (1)

Scott Craner
Scott Craner

Reputation: 152450

Use COUNTIFS with IF:

=IF(COUNTIFS(SHEET1!$A$3:$A$8,SHEET2!$A3,SHEET1!$A$3:$A$8,SHEET2!$D3),SHEET2!$D3,"Additional Value")

This will check if a match exists, if so it just returns the value, if not it returns your string.

Upvotes: 3

Related Questions