Paste data based on multiple criteria

T

Tacrier

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!! :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to count based on multiple criteria & cell comparisons 4
Counting based on multiple criteria 8
Find last column matching criteria 2
How do I filter data by more than one column in excel 0
Adding column data based on match in 2nd column - Help 3
Splitting data into multiple fields. 3
Find partial match from column A,B and fill partial match in C? 4
Counting rows that meet multiple criteria 5

Top