Google表格:引用其他表格上的表格 [英] Google Sheets: Referencing a Table on another sheet

问题描述

我一直在寻找答案，但是还没有答案. 让我为您提供一个我想做的事的例子:

I've been searching for an answer for this and I do not have one yet. Let me provide you with an example of what I would like to do:

我在一张价格表上有一张衬衫的颜色x尺寸的表. 所以在我的桌子上，上面是我的衬衫尺寸(S，M，L，XL等) 左边是我的颜色我不想让每种颜色/设计都有其自己的价值，而是希望使之具有相同的价值，从而可以共享相同的单元格.

I have a table on one sheet of prices for colour x size of the shirt. So for my table, on top are my sizes for the shirt (s, m, l, xl etc) and on the left-hand side are my colours. Instead of having each colour/design have its own value, I want to make it so that those that are the same value, can share the same cell.

因此，在左侧，a2中为红色/黄色，a3中为黑色，a4中为白色/蓝色/金色/棕色，依此类推.

So on the left, it would be red/yellow in a2, black in a3, white/blue/gold/brown in a4 etc and so on.

在主表上，如果有人从下拉菜单中选择颜色(例如蓝色)和大小(例如xl)，它将从与这两个对应的单元格中拉出成本.但是，如果他们执行白色xl操作，它将从同一个调用.

That way on the main sheet if someone selects from the drop-down menus for colour (say blue) and size (say xl) it would pull the cost from the cell that corresponds with those two. But then if they did a white xl it would call from the same one.

任何帮助将不胜感激.

推荐答案

=IFERROR(VLOOKUP(FILTER(Database!A2:A6, ISNUMBER(SEARCH("*"&A2&"*", Database!A2:A6))), 
 Database!A2:G6, IFS(B2="Small",     2, 
                     B2="Medium",    3, 
                     B2="Large",     4, 
                     B2="X-Large",   5, 
                     B2="XX-Large",  6, 
                     B2="XXX-Large", 7), 0), )

数据库表:

这篇关于Google表格:引用其他表格上的表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！