Matching values in a row in excel
Your setup is a bit unclear, but this may do what you want:
=IF(INDEX(I:I,MATCH(A3,Sheet1!A:A,0))="Specified Value",B3,"")
Matching values in a row in excel
Your setup is a bit unclear, but this may do what you want:
=IF(INDEX(I:I,MATCH(A3,Sheet1!A:A,0))="Specified Value",B3,"")