If Cell Equals Text Then Return Another Cell

[razorsharp192]

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?

[Eric Golf]

Hi,

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

Eric

[Yard]

and cue Dave...

;-)