Array formula

[Chimeara]

I have Excel 16 on MacBook
I need to be able to search 2 columns and if there is a match to move the corresponding value in a third column to a fourth column
Example If column A6 has a value equal to column B8 then I want to move the value in column C8 to column D8

 

[Fluff]

How about
=IF(ISNUMBER(MATCH(B1,$A$1:$A$20,0)),C1,"")

 

[Chimeara]

How about
=IF(ISNUMBER(MATCH(B1,$A$1:$A$20,0)),C1,"")

Hi Fluff many thanks for your prompt reply.
I don't think I was very clear with my description maybe this will make it clearer. C2 matches A1 so move B1 to D2

AAAA Closed EEEE
BBBB Open AAAA Closed
CCCC Closed GGGG
DDDD Open CCCC Closed

 

[Fluff]

In that case try
=INDEX($B$1:$B$20,MATCH(C1,$A$1:$A$20,0))

 

[DanteAmor]

How about

=VLOOKUP(C1,$A$1:$B$20,2,0)

 

[Chimeara]

Hi Fluf and DanteAmor thank you so much for your assistance, greatly appreciated

 

[Fluff]

You're welcome & thanks for the feedback

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.