Is a there a lookup formula I can use to match data from multiple columns of data?

I have an excel spreadsheet (which I am unable to upload due to restrictions on my work computer),
In Columns A to D I have data relating to specific crime types, see below headings

A - Crime Type
B - Offence Group
C - Area
D - Domestic Indicator

Then in Columns E to BA, there is month on month data (numbers) for each crime type for each area

E - 01/10/2009
F - 01/11/2009

What I need to be able to do, is in another separate excel workbook, have all the data from columns A to E where is will then look up what is in E to BA and return the data from these columns if the data in the columns A TO E matches that in the first workbook.

Basically, in my initial work book there will be occasions where new data might be added and if this occurs if I just link the two work books by cell reference this will obviously screw up the referencing.

Apologies if this is all a bit wooly, but any assistance would be very gratefully received,

Thanks in advance,

Danni

One suggestion: can you reformat your workbook to have a helper column?
in your helper column: =A1 & B1 & C1 & D1 & E1
then use the helper column with a regular vlookup?

Unfortunately because of the development I need to do further down the line, that option will not work as I need to be able to concatenate the data in work sheet 2 later on.

Ok, you could maybe use a formula like this:
=MATCH(1,IF(A1:A19="a",1)*IF(B1:B19="b",1)*IF(C1:C19="c",1)*IF(D1:D19="d",1,0)*IF(E1:E19="e",1,0),0)
to return your row number, and then use indirect and address functions to get the different columns, for example in column G
=INDIRECT(ADDRESS(MATCH(1,IF(A1:A19="a",1)*IF(B1:B19="b",1)*IF(C1:C19="c",1)*IF(D1:D19="d",1,0)*IF(E1:E19="e",1,0),0),7))

They are array formulas so you need to confirm with ctrl+shift+enter, change A1:A19 to the range you want to look at and "a" to the term to search for in column A and so on. Note, if you fill a whole spreadsheet with these formulas and the search range is big this could take a long time to calculate.