multi-column comparison and lookup

I am very new to excel and I am have a situation where I have five columns the first four of which contain company numbers, account numbers, user numbers and pins. Is there a way to have excel look at those first four columns and return a specific answer based on the combination of those columns? For example:

If column A = 295
and column B = 1515
and column C = 01
and column D = 12345
the return would be "John Smith"
but if all were the same except column D = 12346 then the return would be "Sally Smith".

I truly don't know if this is possible with excel and I hope that I have explained the situation clearly.

Thanks for any help that can be offered.

You don't necessarily need to look at all four values to find a match.

Can we asume that the Pin number is unique? If so, you could simply do an index match formula and match the PIN with the employee.

The attached worksheet uses dynamic named ranges to name the data and this formula to resturn the look up result.

=INDEX(Data,MATCH(H1,Pins,0),5)

Data Validation is also used to provide a drop down list of Pins and this is passed to the formula. The list for the Data Validation is also a dynamic named range.