Retrieve data using index-match formula

[mso3]

Hi friends,

I want to retrieve the address from ‘Personal’ sheet to ‘Label’ sheet.
If there is a ‘Expired’ or ‘Duplicate’ or ‘Company’ remark in column ‘W’ then I want to skip that serial no.
For ex. Here there is a ‘Expired’ remark in cells ‘W10, W16, W17, W22, W25’ So I want to skip serial nos. 2, 8, 9, 14, 17 on ‘Label’ sheet.
I don’t want the serial numbers on ‘Label’ sheet more than the serial numbers on the ‘Personal’ sheet.
I want to convert formulas into values on ‘Label’ sheet.

Any help will be highly appreciated.

Thanking you.