Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

problem in searching and pasting a find cell

  Asked By: Nisha    Date: Nov 16    Category: MS Office    Views: 827
  

i have a problem


i have two worksheets. now in first worksheets i have some ids which my repeat.
means duplicate.

now i have other sheets in which first column have ids again same and repeating
but in different order.

now only ids are same. while other column of same id are different.

now i want to search respective id and place in others columns if the match is
found in to the first sheet.

note in first and second sheets there is column b whose value differs in same
id.

please help me in this

and sorry i cannt copy paste the code due to company security . if u have any
thing in mind please tell me ..

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Alan Palmer     Answered On: Nov 16

Your first worksheet is called Sheet1 in my example, and the second
Sheet2

Sheet1 contains:
A B C
1 Cake 5 3
2 Coffee 2 7
3 Etc.
4

Sheet2 contains:
A B C
1 Coffee Eat Too
2 Cake Hot Drink
3 Etc.
4
In you second worksheet, first empty column  (Column D in my example)
Formula D1 = Vlookup(A1, "Sheet1"!A1:C50,2, False)

You will have to code  the formula properly, and ensure that the selected
range is correct when copying, as you are referring to the lookup range
on a different sheet.

 
Didn't find what you were looking for? Find more on problem in searching and pasting a find cell Or get search suggestion and latest updates.




Tagged: