Formula for matching values in two different sheets, then getting a sum?

**wench_02** · 08-13-2014, 08:56 AM

Can anyone help me with this?

I have a spreadsheet where I have two different sheets; a summary sheet, and a more detailed sheet that lists out items on invoices.

The summary sheet shows invoice number, amount invoiced, and total paid against that invoice.

The detailed sheet goes into more details, and shows whats on the invoice, and any reasons for them not being paid.

I want a formula on the summary sheet that picks up the invoice numer from the details sheet, and then brings through the figures. The details sheet may have more than one line for an invoice number, so the formula needs to be able to add up too.

I've tried a vlookup, but it doesnt seem to work, and I dont think it will do what I want.

**Speshul** · 08-13-2014, 09:10 AM

It's hard to say without a sample spreadsheet, but maybe a vlookup/match

If the headers match on each page: ("Invoice Number", "Invoice Balance" "Date" and so on are all identically spelled and typed, in the same order)

=VLOOKUP(invoice_number_cell,details_sheet,MATCH(header_on_summary_sheet,ALL_headers_on_details_sheet,0),0)

It would look something like this
=VLOOKUP($A2,$A$4:$D$11,MATCH(B$1,Details!$B$1:$I$1,0),0)