Matching Item numbers and moving rows

[Daniel]

Thanks so much to all of you who take time to help us out! You have
no idea how much we appreciate it!

I have two different sets of data. One is a complete listing of all
items I ever put in. The other is a recent invetory with dates of
items that have sold recently.

Data Set one Data Set Two

Item # Quanity Item # Date
1 43 4 11/20/03
3 56 8 12/01/02
4 34 9 10/02/02
6 56
8 57
9 555
14 333

I would like to be able to search data set 1 and when there is a match
with an item # in data set 2 for the date from data set 2 to be
deposited in a new column with the appropriate item #, so I can have
one list with all the data to work with.
Result
Item # Quanity Date
1 43
3 56
4 34 11/20/03
6 56
8 57 12/01/02
9 555 10/02/02
14 333

Thanks again for any and all help!!!!!!!!!!!!

 

[Tom Ogilvy]

assume this is C1

=if(iserror(Vlookup(A1,Data_Set_Two_Range,2,0)),"",Vlookup(A1,Data_Set_Two_R
ange,2,0))

Data_Set_Two_Range should be with abolute reference such as

Sheet2!$A$1:$B$200

Then drag fill this down the column

 

[Cecilkumara Fernando]

Daniel,
Assumed Data Set one is in the range A1:B501,
Data Set Two is in the range E1:F101,
put this formula in C2 and fill down
=Vlookup(A2,$E$1:$F$101,2,0)
if the item nos. are duplicate in Data Set Two then there will be a problem.
Cecil

 

[Ashish Mathur]

Hi,

Name your data set two as range by doing the following

Highlight data set #2 (data set is in G3 to I6)
Go to Insert > name > Define
In "Names in workbook", type range
Click on Add
Click on OK

Suppose data set #1 is in range A3 to C9. In cell D3 type
the foll. formula

IF(ISERROR(VLOOKUP(A3,range,3,FALSE)),"",TEXT(VLOOKUP
(A3,range,3,FALSE),"mm/dd/yyyy"))

Copy this in the other cells of column D

Hope this works. You may mail me if you have any other
problems

Regards,

Ashish Mathur