Hi All,
Is there a solution to this problem.
In A8:A..... is a listing in dollars and cents format.
In B8:B..... is a list of numbers from 1: ...........
Elsewhere on the sheet say H9 down is a VLOOKUP formula that references
the numbers in B8 down and finds the corresponding value from the same row in A8 down.
In other words the values and numbers are side by side.
VLookup only works if the lookup table is in ascending order as in column B.
I wish to sort columns A8:B...... with column A in ascending order. This means that
my lookup table in column B is no longer in ascending order and thus the lookup fails.
Can this problem be overcome by perhaps modifying the lookup formula?
Thankyou,
RC
Is there a solution to this problem.
In A8:A..... is a listing in dollars and cents format.
In B8:B..... is a list of numbers from 1: ...........
Elsewhere on the sheet say H9 down is a VLOOKUP formula that references
the numbers in B8 down and finds the corresponding value from the same row in A8 down.
In other words the values and numbers are side by side.
VLookup only works if the lookup table is in ascending order as in column B.
I wish to sort columns A8:B...... with column A in ascending order. This means that
my lookup table in column B is no longer in ascending order and thus the lookup fails.
Can this problem be overcome by perhaps modifying the lookup formula?
Thankyou,
RC