当前位置: 动力学知识库 > 问答 > 编程问答 >

excel - Auto increment column index with same lookup value (VLOOKUP)

问题描述:

So I got the following lookup:

=VLOOKUP(A20;Employees!A:GE;COLUMN(C:C);FALSE)

The next column should have the samen lookup value(A20), but COLUMN(D:D) as column index number. And this continues for a couple of hundred columns.

Is this possible?

网友答案:

Yes it is, change this formula to =VLOOKUP($A20;Employees!$A:$GE;COLUMN(C:C);FALSE) And then fill to the right. The $ keeps the number or column letter from changing.

分享给朋友:
您可能感兴趣的文章:
随机阅读: