Return multiple lines of info with same reference.

Test Data.xlsx



Hi

Again I need help, I am not having a good day.

In the table which I have attached there are a number of rows which have the ticket number 6117, I need a formula that will return all the row information for each row with 6117. If I just use a simple vlookup it will only return the first row information.

Thank you

Faye

I want them displayed in the table to the right that I have created.

Thanks

Hi DILIPandey

Thank you for the formula, it seems to work for the first two rows but then after that it just displays blank.

thank you

Hi

The formula I have does not seem to be working.

I have entered some more data to show what i am looking for and that the formula I am using doesn't return the data I need.

Thank you all for your help.

FayeTest Data(2) (2).xlsx

That's amazing - thank you!

You are probably all going to be more than sick of me by now.

Thank you all for your help and everything you have each said has worked up to a point.

I am attaching exactly what I am attempting to do just without all the confidential info. I am trying to create an invoicing document in excel as it is only a small business so no need for sage. On the first main sheet labelled Template is the invoice itself where I want all the data to feed through to. On the second sheet is the full breakdown of each individual invoice with their appropriate ticket numbers included.

What I want is that when I copy across all the ticket numbers to the invoice template for it to bring across the item description for each, the qty and the unit price. I will then summarise each ticket at the bottom but the invoice will detail in full also what is being invoiced.

However, the formulas in my sheet currently work for the first 20 or so ticket numbers. But when I select for example E35:E56 from the Invoice list and copy this into the template, the formulas no longer work correctly. I have done this so that you can see. I need the formulas to work no matter which ticket numbers I choose from my invoice list sheet.

I hope this makes sense and that someone can help me.

I appreciate all your help,

FayeInvoicing Template - Test Data.xlsx