Macro for if cells with drop down list equal this, then other cells equal this

Hello,

need some assistance

I have attached the worksheet

We prefer VBA macro

Cells "B3", "D3", and "F3" will be drop down list....Cells "H3" and "J3" will be the result

So if B3, D3, and F3 equal B6, D6, and F6, then H3 and J3 equal H6 and J6

this would apply for the entire worksheet

Thank You

trubio77,

Slightly confused here.

Row 3 contains headers. Do you mean the data you select from DropLists in B1, D1 and F1 triggers what appears in H1 and J1?

Ochimus

see attached workbook.
You can select from drop down lists in B3, D3 and F3.
If there is a match on one of the rows then values from that row for columns H and J will be copied to H3 and J3.
You can modify the macro or add msgbox if you want to cover situations where there is no match.

Hope this helps.

trubio77
Ochimus brings up a good point. You can modify my macro to work with Row 1 instead of 3.
I'll post a revised copy shortly.

Ok, so this is the revised version.
you now work with Row 1.

Let me know if this works for you.

Here's the macro.

HTML Code: 

Thank You Modytrane

This worked