formula result range hypenated numbers

I have two spreadsheets that cant be combined. One is a list of serials assigned to part # and order #, the other is a log of activity, with order number, part #, serial, completed date, etc. What i am trying to do is when i enter the order number in the log, i want is to automatically fill in the part # and range of serial numbers with a hyphen associated with that order number, from the serial spreadsheet. The serials are always consecutive and I already have the part number working with VLOOKUP. Hopefully there is a solution, thank you

example.xls

Attached is an example of the spreadsheets I am working with, except they are located on a network drive, not sure if that matters or not... I am trying to get the first serial separated from the last serial with a hyphen in one cell if possible

worked great just had to remove iferror since my version didnt support it ans replaced with isna