问题描述
我有2张纸:sheet1和sheet2.在sheet1的A列中，我有=RANDBETWEEN(1,100)值.在第二列B上，我想引用sheet2中的列A中的值，但是要使用sheet1中的列A中指出的索引.
I have a document with 2 sheets: sheet1 and sheet2. In sheet1, in column A I have =RANDBETWEEN(1,100) values. On the second column B, I want to reference values from column A from sheet2, however using the indices pointed out in column A from sheet1.
我尝试使用以下命令=sheet2!$A$(sheet1!A1)，但没有成功.您能推荐我一个解决此问题的方法吗?
I tried with the following command, =sheet2!$A$(sheet1!A1) but with no success.Can you please recommend me a solution to this problem?
推荐答案
如果您的设置是这样的(从您的问题中不能完全清楚):
If your set up is thus (not entirely clear on this from your question):
A1中的公式=RANDBETWEEN(1,10)
B1中的公式=INDEX(Sheet2!A:A,A1)
这篇关于Excel-如何从当前工作表中引用另一个工作表中的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！