I am looking for an equation that will first match a value in column A with a value in Column A on another tab and then report the values in that row starting with the first non-null value.

Tab 1

A2:A53 Product Name List
B2:AQ53 Listing of Various text statuses with some as Null Values

Tab 2

A2:A# Product Name List
B2:AA# List various statuses starting with the first non-null value in column B for the matching values in Column A, column C should then report the 2nd non-null value, D the 3rd and so on.