Search the list of Ids in the records

[protocoder]

Dear Experts

I am working every time with around 200 changing unique ids wit
corresponding row entries. It is a pain when list of IDs have t
searched copying and searching in the sheet. Can I get a help to t
search a each of list of (200) ids I want to search with the existin
records and fetch the rest of the row information and to those whic
does not exist in the record a different colored cell. It will reall
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. whic
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 a
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 th
solution tab is where I paste the list of Ids and look to macro searc
for each id, the existing info in the records and fetch the records
Cheers

Thanks in advance


+-------------------------------------------------------------------
|Filename: Search.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=615
+-------------------------------------------------------------------

 

[Claus Busch]

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,Problem!$A$2:$E$100,COLUMN(B1),0))
and copy right to E1 and down


Regards
Claus Busch