If Cell Equals Text Then Return Another Cell

  • I need a formula that If One Cell Equals Certain Text, Then Another Cell Equals The Value Of Another Cell...

    at the mo i've got

    =IF(A2="PAID OUT", "OK", "Not OK")

    but instead of the cell reading OK or Not OK, i need it to equal another cell. ie, if A2="PAID OUT", then =B2

    how do i do that?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!