2 Consecutive Cells match (Column A&B) match 2 other Consecutive cells (Column D&E), copy entry in Column C to Column F

[glbusby1028]

Hi Everyone,

First time posting so hopefully this is clear.

I need a formula that can help find and populate an entry when 2 consecutive cells in the same row match 2 other consecutive cells in other columns.

i.e.
Cell A2 = John
Cell B2 = Smith
Cell C2 = Blue

Cell D13 = John
Cell E13 = Smith
Cell F13 =

I need a formula that would allow for "Blue" to be auto-populated in cell F13 for all similar instances.

Hope this makes sense!

 

[JoeMo]

Excel Workbook
	A	B	C	D	E	F
2	John	Smith	Blue
3	Data	Data	Data
4	Data	Data	Data
5	Data	Data	Data
6	Data	Data	Data
7	Data	Data	Data
8	Data	Data	Data
9	Data	Data	Data
10	Data	Data	Data
11
12
13				John	Smith	Blue
Sheet5

 

[glbusby1028]

Thank you so much for your reply JoeMo. I am getting an error message. Here is what I see when trying to post the formula.

https://drive.google.com/file/d/1Qg51_ZpCJApM2D0HKQ8OhvQ9ZckyRCvo/view

 

[JoeMo]

Thank you so much for your reply JoeMo. I am getting an error message. Here is what I see when trying to post the formula.

https://drive.google.com/file/d/1Qg51_ZpCJApM2D0HKQ8OhvQ9ZckyRCvo/view

I don't download from the web, but my guess is you confirmed the formula by pressing the Enter key. That won't work because it's an array formula as noted in my post. You must confirm it by pressing ctrl+shift+enter keys together. If you do it correctly, Excel will place enclosing {} brackets around the formula in the formula bar.

 

[glbusby1028]

That did it, thank you SOOOOO much Joe. I can't telly you how much I appreciate it!

 

[JoeMo]

That did it, thank you SOOOOO much Joe. I can't telly you how much I appreciate it!

You are welcome - thanks for the reply.