Re: Search and Get Function Help

[Daniel CHEN]

Use vlookup function, assuming that for each specific number (like 2) there
are only one description (like Test2) corresponding to it:
Assume in Sheet1 Range A1 stores 2, then in B1 use the following formula:
=VLOOKUP(A1,Sheet2!$A$1:$B$5,2,FALSE)
which returns Test 2.
Sheet2!$A$1:$B$5 stores the range 1 to 5 and Test1 to Test5.

===== * ===== * ===== * =====
Daniel CHEN

Spreadsheet/VBA Specialist
[email protected]
www.Geocities.com/UDQServices
Try UDQ Consulting Services - Your "Impossible" Task Could Be Someone Else's
"Piece of Cake"
===== * ===== * ===== * =====

==========================================================================================
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]

Thank You so much Daniel! That did the trick!!

Angel