Excel / Google表格：在“ISTEXT”条件下将数据从一个单元格复制到另一个选项卡和单元格

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:

我正在开发Google表格“预算”项目，其中的数据将通过表单条目填充。我想要完成的是以下内容：

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.

我在一个标签（Debit）中动态输入数据，如果行条目中的描述是“Credit”，我希望相邻的单元格值放在另一个标签/单元格中。

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.

我已经尝试了以下所有的多种组合以及错误或不是预期的结果。这可能是VBA的情况，我没有经验。

=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

请查看我的截图，看看我想要完成的事情。谢谢你提前。图形细分

1 个解决方案

#1

Your syntax is all wrong. Please learn the correct syntax.

你的语法都错了。请学习正确的语法。

'Monthly Budget'!C60=

'每月预算'！C60 =

=IF(ISNUMBER(SEARCH ("Credit",Debit!B6)),Debit!C6)

SEARCH syntax

搜索语法
DO NOT use “”. Always use "

不使用 ””。始终使用“
IF Syntax

IF语法
If you want results in a sheet, You do not use need to reference that sheet ( In this case, You don't need to reference monthly budget sheet). But if you want results from a sheet, Then you reference that sheet. Here you need to reference B6 and C6 with a sheet name ( Debit!B6 and Debit!C6)

如果您希望在工作表中显示结果，则不需要使用该工作表（在这种情况下，您不需要参考每月预算表）。但是，如果您需要工作表中的结果，那么您将引用该工作表。在这里你需要用一个工作表名称（借记！B6和借记！C6）来引用B6和C6

#1