Please can you help with a simple formular. I ve got a spreadsheet with a large data. I want to get specific data from that spreadsheet to another workbook.

pls see sample below, so i want to have a formula where if i have 2001 on the second work book it will be equals to the full address and be able to drag down subsequently.

2001  Pittodrie Express 472 Kings Street Aberdeen Grampian AB24 1SA Scotland
2002  Abergele Market Street Abergele Gwynedd LL22 7AA Wales
2004  Addiscombe Express 100-102 Lower Addisco Croyden Surrey CR0 6AD England
2005  Abington Express 348 Wellingborough Ro Northampton Northamptonshire NN1 4EX England
2006  Abertillery Castle Street Abertillery Gwent NP13 1UR Wales

thanks very much


Leave a Reply

Your email address will not be published. Required fields are marked *