https://www.dropbox.com/s/e8hhx35o15...st%20Data.xlsx


I seem to be having trouble adding my spreadsheet so I have put a link to the sheet on dropbox above.

Can someone help I have a formula which is an index and small formula, however it works for the first two rows and then stops working and just returns blank.

I am looking for a formula that I can put into L3, P3 and R3 which will return the correct info for the corresponding ticket number from the table to the left of the sheet. I can't use a simple vlookup as this will only the first row info for a specific ticket number when I need each item on a ticket.

I hope this makes sense, any help you can give on the formula would be a great help. I have tried to rectify it myself but I can't understand why it only works for the first two rows and then stops.

Thank you

Faye