Multiple values in vlookup table A

[capricorn]

Hi All,

Can anyone help regarding multiple values?

I am trying to copy G3 Data to D3.

As you can see column A has more rows than column E. There is a reason behind it, in column A there are few values transaction values are duplicate but it is not in Table B.

What I am trying to do is copy column G value in column D, but when it comes to A17 & A18 I need it to put automatically same value mentioned for Transaction number 0000023600-SH.

I really appreciate.

Thanks.

Capricorn.

[daffodil11]

I married the two tables together with VLOOKUP.

VLOOKUP SOLVES EVERYTHING.xlsx

[capricorn]

@ daffodil11

Thank you so much, you are a job saver.

[daffodil11]

Woo Woo! Glad I could help.