G
Guest
I know it's just a brain-cramp, but I have a question about the lookup array
in VLOOKUP. When I do a VLOOKUP, I specify the lookup value, then I specify
the lookup array which is in a seperate spreadsheet. When the first value is
found in the lookup array, the value I specified is returned.. I then copy
that value down the column I want to place the lookup value in. In each cell
the array value is the same (e.g. A1 thru F100). In a coworkers Excel sheet,
that value for each of the rows changes to like A2 thru F101 and so on. I
don't know what I did to set my spreadsheet to the same absolute array A1
thru F100 ( that is what I want). Mine used to do that too so I'd have to
specify $A$1 thru $F$100 in my formula. What setting di I change?
Thanks,
Dave
in VLOOKUP. When I do a VLOOKUP, I specify the lookup value, then I specify
the lookup array which is in a seperate spreadsheet. When the first value is
found in the lookup array, the value I specified is returned.. I then copy
that value down the column I want to place the lookup value in. In each cell
the array value is the same (e.g. A1 thru F100). In a coworkers Excel sheet,
that value for each of the rows changes to like A2 thru F101 and so on. I
don't know what I did to set my spreadsheet to the same absolute array A1
thru F100 ( that is what I want). Mine used to do that too so I'd have to
specify $A$1 thru $F$100 in my formula. What setting di I change?
Thanks,
Dave