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