Need a formula for the following.

IF sheet 1 cell a2 = Y(text)

THEN sheet 2 cell a2 = sheet 1 cell b2 (number)


tried various things completely stuck on this one.

Thanks