# Lookup problem

#### rjc4

##### Well-known Member
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

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

#### Brian from Maui

##### MrExcel MVP
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).

#### rjc4

##### Well-known Member
Thanks Brian. That has fixed the problem.

Cheers!
RC

Replies
2
Views
205
Replies
5
Views
359
Replies
7
Views
611
Replies
25
Views
848
Replies
14
Views
363

1,195,953
Messages
6,012,511
Members
441,703
Latest member
clivelincoln

### 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.

### Which adblocker are you using?

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

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