It's coming up 0 because there's nothing in cell C21 of Sheet1!why Value is coming zero in SHEET2 C3.
Dear Sir,Try this formula
Code:=IFERROR(CHOOSE((VLOOKUP(A2,SHEET1!B:C,2,0)=0)+1,VLOOKUP(A2,SHEET1!B:C,2,0),VLOOKUP(B2,SHEET1!B:C,2,0)),"")
Dear Sir,It's coming up 0 because there's nothing in cell C21 of Sheet1!