I need help with a complicated Array lookup. Column A has numbers (mostly 0's) with a positive number 1-9 found occassionally as you look down the column. I need the spreadsheet to look down column A, find any number greater than zero and copy the cells from columns B and C adjacent to the number found in column A and past the test in B and C onto a different sheet.
A B C
0 Text 1 Data1
0 Text2 Data2
3 Text 3 Data3
0 Text4 Data4
1 Text5 Data5
1 Text6 Data6
0 Text7 Data7
2 Text8 Data8

Ultimately I would like Text3 Data3 to copy and paste into a cell, then Text5 Data5 to copy and paste into a different cell and the same with Text6 Data6 and Text 8 Data8. Can this be done?