How to find and move a value based on multiple criteria

[JeffZ88]

I have a very large spreadsheet consisting of columns with first names, last
names, ID numbers, and other data. I would like to search and copy ID#'s
associated with names to another sheet, using last names and first names.
For example:
jon smith 1234
mary jones 5678
dave wilson 3456
dave smith 7890

I woud like to find and copy the ID#'s, but as you can see, people might
have the same last name. I used VLOOKUP("last name","range for names from
source sheet",3,FALSE), and get what I need ONLY for those with discreet last
names. When there are more than 1 results with the same last name, I get the
ID # of the first one in the list.

 

[NBVC]

Try:

=Sumproduct(--($A$1:$A$100=X1),--($B$1:$B$100=Y1),$C$1:$C$100)

where X1 and Y1 contain the first and last names to search in Range
A1:B100 and then return number from C1:C100 at corresponding row.


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)

 

[JeffZ88]

Worked like a charm! Thank you!