shawn99michaels
New Member
- Joined
- May 16, 2007
- Messages
- 38
Hi All,
Having a really weird problem this is the vlookup formula I'm using:
=VLOOKUP(C27,'[Fuel Cards and Assigned To Names.xls]Sheet1'!$A$1:$B$24,2,FALSE)
However, when i drag this formula down to the other cells beneath it keeps repeating the same data in the first column.
I don't think it's a problem with referencing as $ signs have been used to avoid this problem. Moreover if I press the fx (function Key) from the excel toolbar it displays the correct values so the formula and referencing seem to be ok but it might be a problem with the auto fill function or somehting if anyone has any idea what to do to solve this then I will be ever so grateful to you.
Having a really weird problem this is the vlookup formula I'm using:
=VLOOKUP(C27,'[Fuel Cards and Assigned To Names.xls]Sheet1'!$A$1:$B$24,2,FALSE)
However, when i drag this formula down to the other cells beneath it keeps repeating the same data in the first column.
I don't think it's a problem with referencing as $ signs have been used to avoid this problem. Moreover if I press the fx (function Key) from the excel toolbar it displays the correct values so the formula and referencing seem to be ok but it might be a problem with the auto fill function or somehting if anyone has any idea what to do to solve this then I will be ever so grateful to you.