look up a selection of data

[Joey]

Hi

I would like to transfer or look up data when keying in a reference
number and bring up all the data regarding the ref number

Eg
Cell A1 = 101, B1 = John and C1 = january
Cell A2 = 102, B2 = Mark and C2 = january
Cell A3 = 103, B3 = Sam and C3 = February
Cell A4 = 101, B4 = John and C4 = March
Cell A5 = 101, B5 = John and C5 = June

When I key in Ref 101 in a chosen cell (eg.A10) then the display should
have all the details

Cell A11 = John, B11 = January
Cell A12 = John, B12 = March
Cell A13 = John, B13 = June

I assume A11, A12 and A13 should also have formulas to generate data
but I could be wrong..

Thanks all and my apologies for the length of this
Joey

 

[Frank Kabel]

Hi
have a look at VLOOKUP for this. See:
http://www.mvps.org/dmcritchie/excel/vlookup.htm

 

[Joey]

Thanks for the link Frank

I'm trying to extract text and data from one table with results in
another.
Although I have a fair understanding of how VLOOKUP works, I still have
a definite problem trying to match and list all the data with the
reference number I search for.

I've also attached a workbook with two sheets to demonstrate it more
clearly

I would be gratefull for any assistance

Thanks
Joey

Attachment filename: timesheet test.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=562495