L
Lise
Hello Everyone
I have two worksheets if the number in sheet 1 cell B2 is in column B of
sheet 2 (say B36) I want the number in A36 to be copied to sheet one.
I have written the following but keep getting #N/A - What am I doing wrong
please?
=IF(COUNTIF(sheet 2!$B$2:$B$576,B2),VLOOKUP(B2,sheet 2!$A$2:$K$511,1,0),0)
I have two worksheets if the number in sheet 1 cell B2 is in column B of
sheet 2 (say B36) I want the number in A36 to be copied to sheet one.
I have written the following but keep getting #N/A - What am I doing wrong
please?
=IF(COUNTIF(sheet 2!$B$2:$B$576,B2),VLOOKUP(B2,sheet 2!$A$2:$K$511,1,0),0)