lillian
Board Regular
- Joined
- Oct 12, 2005
- Messages
- 72
Hi all,
I have a VLookup formula that I thought had an absolute reference, but as I cut and paste, the range keeps shifting. Here's the formula:
=VLOOKUP(E6,'[January 2006 Schedule.xls]Sheet1'!$A1:$C65,3,FALSE)
Next formula has $A2:$C66 and so on...
Edit for clarity
I have a VLookup formula that I thought had an absolute reference, but as I cut and paste, the range keeps shifting. Here's the formula:
=VLOOKUP(E6,'[January 2006 Schedule.xls]Sheet1'!$A1:$C65,3,FALSE)
Next formula has $A2:$C66 and so on...
Edit for clarity