确定另一张表的行的引用行? [英] Determining a row's referenced row for another sheet?
问题描述
我的库存表:
项目数量单位卡路里碳水化合物蛋白脂肪
鸡大腿(w /骨)1盎司37 0 3.73 2.3
我的项目列表被吃掉,出售,取决于哪个:这是呈现的表
项目:测量单位碳水化合物蛋白脂肪
鸡大腿(w /骨)4.6
原始的公式,或者我认为他们可能是:我不知道如何自动选择卡路里/碳水化合物等用于计算:(
项目:测量单位...碳水化合物蛋白质脂肪
= Inventory.A2 4.6 = A2的E列的表/行#B2
...任何人都知道如何在excel中执行此操作?甚至可能吗?
假设度量
在C1中, Unit
在C1中,您对 Calories
不感兴趣所以D1是空白),碳水化合物
/ 蛋白质
/ Fat
分别在E1:G1,然后在C2:
=(IF(C $ 1 =,,IF ISTEXT(VLOOKUP($ A2,库存$ A:$ G,COLUMN(),0)),VLOOKUP($ A2,库存$ A:$ G,COLUMN(),0),$ B2 * VLOOKUP($ A2 ,库存!$ A:$ G,COLUMN(),0)))
并跨越到G2可能适合。
I have a table that includes an "inventory" item's name, as well as its base weight and associated carbs, protein, fat, etc. On another sheet, there's a table that references the inventory item's name, and once I input the actual weight, I'd like my other calculated columns to automatically figure out the carbs, protein, fat, etc. for that selected item and weight. For example...
My "inventory" sheet:
Item Amount Unit Calories Carbs Protein Fat
Chicken Thigh (w/ Bone) 1 oz 37 0 3.73 2.3
And my list of items eaten, sold, whichever: This is the rendered table
Item: Measure Unit Carbs Protein Fat
Chicken Thigh (w/ Bone) 4.6
And the raw formulas, or what I think they may be: I have no idea how to automatically select calories/carbs/etc to use for calculations :(
Item: Measure Unit ... Carbs ... Protein ... Fat
=Inventory.A2 4.6 =Sheet/Row of A2's E column * B2
...anyone know how to do this in excel? Is it even possible?
Assuming Measure
is in B1, Unit
in C1, you are not interested in Calories
(so D1 is blank), Carbs
/Protein
/Fat
are in E1:G1 respectively, then in C2:
=(IF(C$1="","",IF(ISTEXT(VLOOKUP($A2,Inventory!$A:$G,COLUMN(),0)),VLOOKUP($A2,Inventory!$A:$G,COLUMN(),0),$B2*VLOOKUP($A2,Inventory!$A:$G,COLUMN(),0))))
and copied across to G2 might suit.
这篇关于确定另一张表的行的引用行?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!