Write a proper Index and match function
Budget: $10 – $30 USD
Column A has a code and a corresponding qty in Column B
The Same codes that are in Column A are also in Column C
Make Column D reflect the proper qty data which is in column B by Matching Column C to Column A
The Same codes that are in Column A are also in Column C
Make Column D reflect the proper qty data which is in column B by Matching Column C to Column A