vlookup (or something else??)

  • Thread starter Thread starter Marco J.L.
  • Start date Start date
M

Marco J.L.

Hello

i've 2 worksheets :

Worksheet 1 :
Col A : only values : 0 and 1
Col B & C : Data1 and Data2

Worksheet 2 :
I only want the colums B & C from 'Worksheer 1' and only those where in
Colum A from 'Worksheet 1' the value is 1 or higher!

Which formula do I've to use?

If you don't understand my question, I put it in an html file with an
example : http://www.hexan.nl/news/excel.htm

Thanks,

Marco J.L.
 
Hi
I would try to use 'Data - Filter - Advanced Filter' for
transfering the values to a separate sheet
 
Vlookup will not work as thje look up referance is not
unique. You can try "IF" function for example "IF
(A1>=1,B1,""). you may find blank rows in i the results
work sheet. you can use special "GOTO" menu to selects the
data only with data and paset special skip blank function
to eleminate the rows

sathish
 
Back
Top