Invoice Sales Tracker is messing up the invoice items

**Kristina86** · 03-05-2015, 06:17 AM

Hi!

I needed an excel invoice sales tracker to use for my company, and so I found one in Excel free templates. Since it did not match my needs completely I have made some adjustments. As you can see from attachement the Invoice sheet uses the number of the invoice to filter the Invoice Details sheet and show the appropriate results. The problem is it messes up results, which makes it unusable.

I am a begginer with excel formulas, and the one you see in the Invoice sheet are actualy left from the original template. Can someone please help me? I tried to figure out the problem, but it is far beyond my excell knowledge.
TRIAL.xlsx

**samba_ravi** · 03-05-2015, 06:47 AM

B14=IFERROR(INDEX(InvoiceDetails,SMALL(INDEX((TRIM(InvoiceDetails[Invoice '#])<>TRIM(rngInvoice))*10^10+ROW(InvoiceDetails[Invoice '#])-ROW(InvoiceDetails[[#Headers],[Description]]),0),ROW(1:1)),MATCH(B$13,InvoiceDetails[#Headers],0)),"")
Try this and copy across

Invoice Sales Tracker is messing up the invoice items

LinkBack

Thread Tools

Rate This Thread

Display

Invoice Sales Tracker is messing up the invoice items

Re: Invoice Sales Tracker is messing up the invoice items

Thread Information

Users Browsing this Thread

Similar Threads

Invoice Tracker

Populate monthly invoice tracker

Excel Sales Invoice Tracker

A4 date of invoice - E4 invoice status - F4 Date invoice was paid - G4 number of days invo

Sales invoice which changes stock

Bookmarks

Bookmarks

Posting Permissions