Another option:

=index(othersheet!$e$1:$e$10,
match(1,(a2=othersheet!$a$1:$a$100)*(b2=othersheet !$b$1:$b$100)
*(c2=othersheet!$c$1:$c$100)*(d2=othersheet!$d$1:$ d$100),0))



Connie wrote:

I have 2 spreadsheets with data from 2 systems.

What I need is to take specific data from sheet 1 and match it to the
corresponding line in sheet 2. The problem comes in that each sheet only has
a unique entry if I search based on a combination of 4 columns (item #, date,
location and quantity).

For any one of these search items there will multiple entries, but for the
combination of all 4 there should be one unique entry.

How can I accomplish this to compare the two spreadsheets?

--

Dave Peterson