ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Lookup all values on next tab (https://www.excelbanter.com/excel-discussion-misc-queries/166087-lookup-all-values-next-tab.html)

CGDorn

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

Farhad

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



All times are GMT +1. The time now is 02:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com