Excel-如何从当前工作表中引用另一个工作表中的值 [英] Excel - How to reference a value from another sheet with a reference from current sheet

问题描述

我有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-如何从当前工作表中引用另一个工作表中的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！