look up a selection of data

  • Thread starter Thread starter Joey
  • Start date Start date
J

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
 
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
 
Back
Top