Question

Excel中sheet1中J3=sheet2中H7,sheet1中J4=sheet2中I7,sheet1中J5=sheet2中J7依次

想要在sheet1中橘黄色表格中录的数值在sheet2中能自动填录，跪求这样的公式 万分感谢





Answer 1

=indirect(address(7,row(A10),,,"sheet2"))
看你的标题去了。郁闷。修改下公式：
=indirect(address(column(Y1),10,,,"sheet1")) 或则
=VLOOKUP(H3,$g$:$j$,4,0)

Answer 2

sheet2的H7输入：
=vlookup(h3,sheet1!$g:$j,4,0)
向右拉