Matching formula

[Bill]

Dear all

I have in sheet 1 the following

Column A first names
Column B second names
Column C registration numbers
Column D sales


In sheet 2 i have Column A first names
Column B second names

I want the following.

In the sheet 2 in column C i want
When the first name of sheet 2 is equal to first name of
sheet 1 and the last name of sheet 1 is equal to the last
name of sheet 2 then bring me the registration number to
sheet 2 from the sheet 1.


Is it possible?

 

[Frank Kabel]

Hi
try the following array formual (entered with CTRL+SHIFT+ENTER):
=INDEX('sheet1'!$C$1:$C$100,MATCH(1,('sheet1'!$A$1:$A$100=a1)*('sheet1'
!$B$1:$B$100=B1),0))