Cell Reference if condition match.

Hello Again,

I was trying to display a information from other cells if the condition is match.

For example:

If C1:E1 match any cell in column B Column A data will be displayed in columns F, G & H

Honestly speaking i don't know how to explain. I am attaching a sample for more clarification.

Kindly see the attachment.

How about this:

Do you mean this?

=IF(C2="Yes",$A2,"")

so simple thanks for your efforts. topic closed and reputation added.