Issue on populating Excel column based on matched rows

1
votes

I am working on the below sheet. How I can run a formula to loop into the column D rows and find the exact match in the column A rows and then populate columns E and F from columns B and C while D and A matches?

It would be great if I have this in a Formula instead of running in Macro

enter image description here

1
excelvbaexcel-formula

1 Answers

3
votes

Put this into E1 and drag it right and down.

=iferror(vlookup($D1, $A:$C, column(B:B), false), "")