Using Vlookup - Need help

[Prabhu989]

Hello,


I have a set of data sorted by the Order_id Sorted column with it's associated data fields like amount, status etc. Theres another set of columns, order_id Unsorted and it's corresponding card_type Unsorted column.


Now the unsorted Order_id's exist in the sorted order_id's, theyr just randomized. I just want the card_type assigned to the sorted order_id's by matching the two order_id's.


Hope that's clear?


Here's a sample:


[TABLE="width: 439"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]order_id Sorted[/TD]
[TD]Card Type Sorted ?[/TD]
[TD]order_id Unsorted[/TD]
[TD]card_type Unsorted[/TD]
[/TR]
[TR]
[TD]IKP-1490337362-6599[/TD]
[TD][/TD]
[TD]REG-1475288853-6512[/TD]
[TD]CREDIT[/TD]
[/TR]
[TR]
[TD]REG-1490336608-1999[/TD]
[TD][/TD]
[TD]REG-1475302612-6126[/TD]
[TD]CREDIT[/TD]
[/TR]
[TR]
[TD]REG-1475302612-6126[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]REG-1490336003-8008[/TD]
[TD][/TD]
[TD]DON-1475313483-2840[/TD]
[TD]CREDIT[/TD]
[/TR]
[TR]
[TD]REG-1490335828-2197[/TD]
[TD][/TD]
[TD]DON-1475306752-3817[/TD]
[TD]CREDIT[/TD]
[/TR]
[TR]
[TD]REG-1490335695-9367[/TD]
[TD][/TD]
[TD]REG-1475342658-1172[/TD]
[TD]DEBIT


[/TD]
[/TR]
</tbody>[/TABLE]


Thanks.

 

[oldbrewer]

can you use offset with match because then it does not matter that the target range is not sorted

 

[muizac]

Assuming your data starts in A1. In column B1 =vlookup(A1,$D1:$E$10,2,0) [ENTER USING CNTL+ALT+ENTER]