Excel/Google Sheets: Copying data from one cell upon "ISTEXT" condition to another tab and cell

I'm working on a Google Sheets "Budget" project with data that will be populated via form entries. What I'm trying to accomplish is the following:

I have data entered dynamically in a tab (Debit), If the description in the line entry is "Credit", I want the adjacent cell-value to be placed in another tab/cell.

I have tried many combination of the following all with either errors or not the expected outcome.This may be a case for VBA, of which I have NO experience with.

=IF(Debit!B6="Credit",”'Monthly Budget'!C60”,”Fail”)
=IF(ISNUMBER(SEARCH(B6="Credit",C6 'Monthly Budget'!C60))
=IF(B6="Credit",'Monthly Budget'!C60,"")

Please see my screenshot for a visual representation of what I'm trying to accomplish.Thank you in advance.Graphic Breakdown