Vlookup Help

[davidhall]

I have a vlookup function on worksheet 1 that references a fixed range of data on worksheet 2. On worksheet 2, I will be copying and pasting data from another spreadsheet onto worksheet 2 and for some reason the range formula on worksheet 1 changes to =VLOOKUP($B25,'Oper Data'!#REF!,2,FALSE), therefore, not returning my date. The formula should look like this =VLOOKUP($B25,'Oper Data'!$B$1:$B$150,2,FALSE)

Any suggestions?

 

[jmthompson]

Are you pasting or inserting the copied cells?

 

[jim may]

Is this always "$B$1:$B$150" or does it vary to say "$B$1:$B$250" ?

 

[davidhall]

It is always $b$1:$b$150

I am copy the cells from another spreadsheet and pasting them in worksheet 2. I have tried different methods of pasting and haven't been successful

 

[MrKowz]

Try replacing the formula with:

=VLOOKUP($B25,INDIRECT("'Oper Data'!$B$1:$B$150"),2,FALSE)

 

[davidhall]

Thanks!!!!! It works now

 

[jim may]

Your range must include at least Column C as you are using the "2" column reference...

=VLOOKUP($B25,'Oper Data'!$B$1:$C$150,2,FALSE)