Hello

=VLOOKUP(F2,'Payment Method'!A1:B10,2,FALSE)
by this formula i want to look the value given in the cell "F2" in the table
A1:B10 on the sheet "Payment Method". A1:B10 Table is fixed So i dont want
any change in the range of this table (A1:b10). When i copy this formula to
the very next down cell of the same column, it becomes
=VLOOKUP(F3,'Payment Method'!A2:B11,2,FALSE). Table Range is changed which
is not required Because i want to look the value only in the following range
(A1:B10).
I want that when i copy the this formula to very next down cell, its table
value (A1:b10) Shouldnt change whenever the value of the "F" cell should be
changed. it should be from F2 to F10 if i copy it in next 10 cells.