Search the list of Ids in the records
 

Dear Experts

I am working every time with around 200 changing unique ids with corresponding row entries. It is a pain when list of IDs have to searched copying and searching in the sheet. Can I get a help to to search a each of list of (200) ids I want to search with the existing records and fetch the rest of the row information and to those which does not exist in the record a different colored cell. It will really help me.
1. The existing records list could be 500 max.
2. The list of records I would search would be 200.

How about I copy the records I want to search in the another tab. which searches the record in the first tab and displays result in second tab. Is this feasible.

Sample Problem:
The Data:
Unique Id Case Officer Description Assigned
A12323 Russel Blah Andrew
A12325 Smith Blah Jacqie
C23434 Clive Blah Kelvin
C23467 Karen Blah Peter
etc etc etc etc

I want to search the data for C3434534, A12323, A93434, C23434. C23467

in the second tab may be first column and the I must get the answer as follows

C3434534
A12323 Russel Blah Andrew
A93434
C23434 Clive Blah Kelvin
C23467 Karen Blah Peter

The colored ones meaning the records do not exist.

Please can you help me ...

The attached file has two tabs the first tab is records (500) and the solution tab is where I paste the list of Ids and look to macro search for each id, the existing info in the records and fetch the records. Cheers

Thanks in advance
P

Search the list of Ids in the records
 

Hi,

Am Wed, 10 Oct 2012 10:07:08 +0000 schrieb protocoder:

Sample Problem:
The Data:
Unique Id Case Officer Description Assigned
A12323 Russel Blah Andrew
A12325 Smith Blah Jacqie
C23434 Clive Blah Kelvin
C23467 Karen Blah Peter
etc etc etc etc

I want to search the data for C3434534, A12323, A93434, C23434. C23467

in the second tab may be first column and the I must get the answer as
follows

C3434534
A12323 Russel Blah Andrew
A93434
C23434 Clive Blah Kelvin
C23467 Karen Blah Peter

try in B1:
=IF(COUNTIF(Problem!$A:$A,$A1)=0,"",VLOOKUP($A1,Pr oblem!$A$2:$E$100,COLUMN(B1),0))
and copy right to E1 and down


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2