how to construct Match with IF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to match 1 value in column 1 and 1 value in column 2 from Worksheet 1 to return the Description in Worksheet 2. What kind of functions should I use and how to construct the function. Thank you

Worksheet

Column 1 Column2 Descriptio
aa 123 Condition
bb 123 Condition
cc 123 Condition

Worksheet

Column 1 Column 2 Descriptio
aa 123 ??
bb 123 ??
cc 123 ??
 
one way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=INDEX(Sheet1!C:C,MATCH(1, (Sheet1!$A$1:$A$1000=A5) *
(Sheet1!$B$1:$B$1000=B5), FALSE))
 
Back
Top