|First, I asked you to read the instructions on how to post data in this forum by clicking on the blue line at the end of my posts. It does not appear that you have followed those instructions. If you had, your data would have looked like this:|
B C D E
1 1148 PETER 3210 MARK
2 1234 ALEX 1148 PETER
3 3210 MARK 1234 ALEX
Please try to follow those posting instructions in the future.
Second, unless I don't understand what you are trying to do, VLOOKUP should work fine.
If you start with this...
B C D E
1 1148 =VLOOKUP(B1,$D$1:$E$3,2,0) 3210 MARK
2 1148 PETER
3 1234 ALEX
...you will get Peter in C1.
Using 0 (or FALSE) as the range_lookup argument means that the table_array does not have to be sorted in any order.
The Help files on VLOOKUP explain the use of the range_lookup argument.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.