I would like to be able to enter a Product Code into Cell A2 and then Cells B2 and C2 enter the values in Cells F2 and G2

Match Code_compressed.jpg

Which code needs to go into B2 and C2 for this to happen?

Compare Then Enter Data.xlsx

I've searched all over the internet and forums trying to find a solution but it's proving difficult.

I'd like to thank again everyone that has helped me on this site previously! You guys are the best!

Cheers
Russell