vlookup / index for a large spreadsheet

[Guest]

Hi

I am trying to lookup a name for an employee ID. I have tried vlookup and
the index functions. The initial setup works; however, when I copy / paste
the function, the subsequent values for the array changes.

originial function
=INDEX(EIDs!A1:B41,MATCH(G113,EIDs!A1:A41,0),2)
function further down in spreadsheet
=INDEX(EIDs!A13:B53,MATCH(G125,EIDs!A13:A53,0),2)

I have about 6000 records I'm trying to update, it would be nice if I could
somehow keep the range the same.

Does anyone have any suggestions?

Thank you
Cynthia

 

[Guest]

Use absolute cell references for your range:

$A$1:$B$41

The $ symbol prevents Excel from incrementing the reference when the formula
is copied.

Look up Absolute and Relative cell references in Excel Help for more info on
this.

HTH,
Elkar

 

[Guest]

Thanks! That worked

Use absolute cell references for your range:

$A$1:$B$41

The $ symbol prevents Excel from incrementing the reference when the formula
is copied.

Look up Absolute and Relative cell references in Excel Help for more info on
this.

HTH,
Elkar