Hello,

I have a worksheet with a pick list where users can select an option from a list - I have another tab which I am working on tryng to link with the working sheet but only to return a few departments not all

So in the pick list -

There will be

Dept. PO Start Date PO Number Comments
Finance
HR
Marketing
R&D
IT
Other Admin.

I only want to return the 4 columns for HR, Finance and Marketing - so I have done an IF OR formula based on A1 on the first and second tab - the results however if there isn't a match returns a blank cell as it is false - is there a way of skipping the blanks so it appears in order with no blanks and so that I can get PO Start Date, nnumber and Comments in the worksheet too.

Thanks,