Lookup/Index/Match help!

[Kirsty]

Hello!

I have two spreadsheets in the same workbook: BAB1 and DATA.

BAB1 shows all my clients, their Invoice Refs (Column D) and other
unimportant information.
DATA shows all clients, their Invoice Refs (Column A) and the total
payments they've made (Column U).

In column Q in BAB1 i want to return the total payments received
against that Invoice Ref, from the DATA sheet.

What formula should I use to do this? There are more records on the
DATA sheet than there is on the BAB1 sheet so it's not simply a case
of sorting into order and picking them out.

Thanks!

 

[Paul]

Hello!

I have two spreadsheets in the same workbook: BAB1 and DATA.

BAB1 shows all my clients, their Invoice Refs (Column D) and other
unimportant information.
DATA shows all clients, their Invoice Refs (Column A) and the total
payments they've made (Column U).

In column Q in BAB1 i want to return the total payments received
against that Invoice Ref, from the DATA sheet.

What formula should I use to do this? There are more records on the
DATA sheet than there is on the BAB1 sheet so it's not simply a case
of sorting into order and picking them out.

Thanks!

In Q1 of BAB1 put the formula
=VLOOKUP(D1,DATA!$A:$U,21,0)
and copy down column Q as far as required.