Hi. I'm trying to compare columns from one sheet to another, and if
there is a match, pull data in a column next to it. I tried to use the
DGET, but I couldn't get it to work properly. See example below:

Worksheet 1
2
4
1
2
5
4
3

Worksheet 2
1 Test 1
2 Test 2
3 Test 3
4 Test 4
5 Test 5

What I'm looking to do is have Worksheet 1 show the description next to
the number, see below:
2 Test 2
4 Test 4
1 Test 1
2 Test 2
5 Test 5
4 Test 4
3 Test 3


I know that this can easily be done with sql, but I wasn't sure if I
could do it that easily in excel. Thanks in advance for your help.

Angel


--
angelsimpson
------------------------------------------------------------------------
angelsimpson's Profile: http://www.excelforum.com/member.php...o&userid=23931
View this thread: http://www.excelforum.com/showthread...hreadid=375625