Hi Lee

On your Sales sheet enter this formula into J1 - then copy across to P and
down as many rows as you need.

=(IF(AND($A1=Bookings!$A1,$B1=Bookings!$B1),Bookin gs!C1,""))

HTH - Trevor Williams

"Gemi" wrote:

I have a workbook that contains two worksheets: Bookings and Sales. If the
data in columns Bookings A and B match the data in columns Sales A and B I
want the data in Sales Columns C-I to be entered in Bookings Columns J-P.
Backround I have two workbooks with customer sales and bookings and want to
combine it on one sheet. Not all customers are listed on both. Bookings has
2617 rows and Sales has 2161 rows. The one common factor betweent hem is
columns A and B. Any help would be greatly appreciated!


Thank you,
Lee