Needing some help here can't seem to get the IF(COUNTIF) statement correct.
I have two worksheets - Sheet 1 and Sheet 2
Sheet 1 has two columns A and B
Sheet 2 has two columns B and C
Column B contains the same words/items on both sheets.
Column C contains the part numbers of the items in column B
I want to enter info into column B Sheet 1 - if that matches any cells in column B Sheet 2 range then the info from the same row of sheet 2 but Column C is put into column A of sheet 1
I can get it working so that either a yes or a no is entered into column A Sheet 1 but not the part number from column C Sheet 2
It's a little tricky to explain so hope the above makes some sense.
Thanks heaps champs!!