Lookup/Index/Match help!

  • Thread starter Thread starter Kirsty
  • Start date Start date
K

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!
 
Kirsty said:
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!
Click to expand...

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