Just to forewarn, I am an amateur at formulas. I do not have a formula that I can display for editing as I do not know enough to get started. I am attempting to lookup all incedences of a unit's serial number and status information related to that serial number.

My request is this:

1.) I need to build a formula that allows the user to enter the serial number (text? - a numeric value that has a hyphen in it),

2.) and find and return all incedences of that value located in a column (VLOOKUP?),

3.) that could be located in any number of the 12 worksheets in this single workbook.

4.) In addition, the return would also include that initial value and the following 4 cells in that row.

5.) I do know that the range_lookup should be FALSE as I need exact values.

6.) If it were a perfect world, it would return a "None" in the event there were no matches.

Any help at all would be greatly appreciated.