Posts by herstjori

Re: If cell equals another cell in another worksheet info entered into first workshee

Thanks Dan - perfect.

Hi Guys,

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!!