Lookup problem

rjc4

Well-known Member
Joined
Nov 6, 2004
Messages
502
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
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
rjc4 said:
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

Not sure how you're using Vlookup here, but the lookup column need not be sorted if the 4th argument is set to 0 (False).
 
Upvote 0

Forum statistics

Threads
1,213,560
Messages
6,114,306
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top