Max,

found your answer below and tried to adjust it to a question I raised today,
"colating data from a table for a bespoke report". I used it to find the
first record but have problems with it finding futher records can you help
please.

(see below for example) Basically In cell a1 I have a drop down that allows
you to select a name so that all the differant Proj Code (from a 1020 row
list) against that name are shown on seperate rows in preformated report.
Once I have that data by means of a vlookup I have a formula that will show
the rest of the data.

Proj Code Name

PC01 colin
PC01 fred jones
PC12 colin
PC13 fred jones
PC14 fred jones
PC19 colin

if you can help could you post a report against that question please.

many thanks in advance.

UKMAN



"Max" wrote:

I need to type a number in sheet 1, a2.. It will go to sheet 2 and match
that number with all the numbers in column a and copy the name next to that
number back to sheet 1,b2

In Sheet1,
Put this in B2: =INDEX(Sheet2!B:B,MATCH($A2,Sheet2!$A:$A,0))
Copy down
--
Max
Singapore
---