Looking up Specific Criteria in line item and doing a LookUP

Are you sure that you have quoted the correct ID No for LNID and IC Tickets???

I used this to extract the 10 digit numbers:

=IFERROR(LOOKUP(10^10,MID(SUBSTITUTE(A2," ","a"),ROW(INDIRECT("1:"&LEN(A2)-9)),10)/ISERROR(--MID(" "&A2,ROW(INDIRECT("1:"&LEN(A2)-9)),1))/ISERROR(--MID(A2&" ",ROW(INDIRECT("11:"&LEN(A2)+1)),1))),"").

This can then be used to lookup the company name, like this:

=INDEX($A$12:$A$16,MATCH(IFERROR(LOOKUP(10^10,MID(SUBSTITUTE(A2," ","a"),ROW(INDIRECT("1:"&LEN(A2)-9)),10)
/ISERROR(--MID(" "&A2,ROW(INDIRECT("1:"&LEN(A2)-9)),1))/ISERROR(--MID(A2&" ",ROW(INDIRECT("11:"&LEN(A2)+1)),1))),""),$B$12:$B$16,0))

But it returns two errors, where I think you have provided an incorrect 10 digit number...