0

I have 2 sheets:-

Sheet A has description (column B) and sales price (column C), Sheet B has identical columns, description (Column B) and purchase price (Column A). However Sheet B have 1000 lines and Sheet A have only 50 lines.

I want to get the purchase price from Sheet B to Sheet A using the description as the commonality

So

Sheet A column B has the descriptions and column C the sales price. Sheet B column B has the descriptions and column C the purchase price

I need a formula or script that will look through each row on sheet B looking in column B to find the match with the cell in column B of sheet A and then copy the value from column C in sheet B to the correct row cell in column D in sheet A

I will then have 1 sheet with a number of products that shows sales and purchase price based on the description

Any ideas welcome

Mak

JvdV
  • 70,606
  • 8
  • 39
  • 70
Mak
  • 1
  • 2
    Have you tried VLOOKUP https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1 – PaulS Jan 31 '20 at 09:28
  • 1
    What you describe is literally the VLOOKUP function :-) – Daghan Jan 31 '20 at 09:28
  • What you want is either `VLOOKUP`, but try get in the habit of using a combination of `INDEX` and `MATCH`. [Here](https://stackoverflow.com/a/58436658/9758194) is a short explanation why. – JvdV Jan 31 '20 at 09:38

0 Answers0