How can I extract data from a list that meets certain criteria?

**fsimek** · 04-28-2008, 03:15 PM

From a master list I am picking out certain clients to receive updates. How can I extract only the clients I am trying to reach into another tab. I have tried writing an array formula, but it requires me to return some sort of value if the search criteria is not met. How can I pull over only the values I mark.

FYI One of the columns in the master list is set up so I can enter an "X" in it if that particular client needs to be contacted. I would like to use that column data to decipher who all gets pulled over.

Thanks in advance!

**shg** · 04-28-2008, 03:24 PM

Most likely is.

Would you please edit your post to have a title descriptive of your problem?

Thanks.

**shg** · 04-28-2008, 03:49 PM

Thank you.

Can you post a workbook with an example of what you have and what you want?

**fsimek** · 04-28-2008, 04:04 PM

Here is an example of what I currently have. What I need is a way to pull over all pertinent client data, ie name and fax # to Tab 2, with out pulling over any NA's or blanks. The formulaI am running in Columns N and O pull over the correct data if there is an X in column M. Now, I only want those two columns to pull over to Tab 2.