Paste data based on multiple criteria
 

Hi again!

On worksheet 1 I would like to paste data into K4418 to 10641, L4418:10641
and M4418:10641 by matching up client names, invoice amounts and invoice date
to return the paste data.

Column B5:4406 contains client names in "First Name Middle Name (if
applicable) Last Name" Order
Column F5:4406 contains invoice amounts
Column G5:4406 contains invoice numbers
Column I5:4406 contains invoice dates
Column K5:4406 contains Pay to
Column L5:4406 contains cheque number
column M5:4406 contains description

Column B4418:10641 contains client names in "Last Name, First Name Middle
Name (if applicable)" Order
Column F4418:10641 contains invoice amounts
Column G4418:10641 contains invoice numbers
Column I4418:10641 contains invoice dates
Column K4418:10641 contains BLANK Pay to
Column L4418:10641 contains BLANK cheque number
column M5:4406 contains BLANK description


Would I need to change the order of the client names first in Column B? If
so how do i do this? What can function can I use after that?

Thanks!! :)