doctorbill
asked on
excel vlookup
I have a question the VLOOKUP formula
Example:
=VLOOKup(C1,D1:F100,2,FALS E)
If I enter this formula into a cell and then use autofill to drag the formula down to the following cells, the values increase by 1 each time. Is there a way of stopping the value of F increasing by 1 each time. I don't see the need for this unless it is the way the formula needs to work.
Example:
=VLOOKup(C1,D1:F100,2,FALS
If I enter this formula into a cell and then use autofill to drag the formula down to the following cells, the values increase by 1 each time. Is there a way of stopping the value of F increasing by 1 each time. I don't see the need for this unless it is the way the formula needs to work.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER