Lookup all values on next tab
 

Suppose I have some data and an if function in Column A. The If function
returns a "Yes" if 4 sets of criteria are met. If on another tab I want to
import all data with Yes in the A column into the new tab and I do not want
spaces between rows.

For example, in column A says if(and(D1=1, E2=1, F3=1, G4=1),"YES","") and I
want the other tab to dispay all the information from columns B, C, D, E, F &
G. Can this be done? Thanks in advance

Lookup all values on next tab
 

Hi,

I think the easiest way is to autofilter the column A on "YES" and then
select the filtered data and copy and paste in other tab.

Thanks,
--
Farhad Hodjat


"CGDorn" wrote:

Suppose I have some data and an if function in Column A. The If function
returns a "Yes" if 4 sets of criteria are met. If on another tab I want to
import all data with Yes in the A column into the new tab and I do not want
spaces between rows.

For example, in column A says if(and(D1=1, E2=1, F3=1, G4=1),"YES","") and I
want the other tab to dispay all the information from columns B, C, D, E, F &
G. Can this be done? Thanks in advance