从一个工作表中获取值并更新到另一个工作表的单元格值 [英] get value from one sheet and update to cell values of another sheet

查看:132
本文介绍了从一个工作表中获取值并更新到另一个工作表的单元格值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

您好b $ b

我需要excel的帮助



sheet2中的金额需要将它们放入工作表中1列,如果它在同一张表中增加另一列将为0



如前所述



在sheet2中

Hi
I need a help in excel

there is amounts in sheet2 and need to get them in sheet 1 column and if it increase anothe column in same sheet will be 0

as ex like this

in sheet2

wp02	2000
wp05	9000
wp10	2700
wp20	2500
wp23	5000





sheet 1

wp02 2700

wp03 2850

wp04 1200

wp05 9650



partpayment

1

1

0

0



if i在sheet2中添加wp05值,它应该更新sheet1中的wp05和

partpayemnt应为0



它不适用于我的公式

= IF(D2 = 0,0,IF(Sheet2!B:B< = D2,0,1))



帮我排序o这个



Asathecode



sheet 1
wp02 2700
wp03 2850
wp04 1200
wp05 9650

partpayment
1
1
0
0

if i add wp05 value in sheet2 it should update wp05 in sheet1 and
partpayemnt should be 0

it wont work for my formula
=IF(D2=0,0,IF(Sheet2!B:B<=D2,0,1))

help me to sort out this

Asathecode

推荐答案

你应该读一下 SUMIF SUMPRODUCT

https://support.office.com/en-us/article/SUMIF-function-169b8c99-c05c-4483-a712-1697a653039b [ ^ ]

https:// support。 office.com/en-us/article/SUMPRODUCT-function-16753e75-9f68-4874-94ac-4d2145a2fd2e [ ^ ]
You should read about SUMIF or SUMPRODUCT
https://support.office.com/en-us/article/SUMIF-function-169b8c99-c05c-4483-a712-1697a653039b[^]
https://support.office.com/en-us/article/SUMPRODUCT-function-16753e75-9f68-4874-94ac-4d2145a2fd2e[^]


这篇关于从一个工作表中获取值并更新到另一个工作表的单元格值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
相关文章
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆