dear all,

i need to combine two worksheets into one and display the 3rd one.

worksheet1 worksheet2
name value1 value2 name value3 value4
a 4 6 e 2 8
b 12 18 f 30 60
c 45 55 g 8 25

if value1=value3 and also value2<=value4, display the row in worksheet1 and
the row in worksheet2 into the same row in the 3rd worksheet.
So, the display should be
a 4 6 e 2 8
b 12 18 g 8 25
c 45 55 f 30 60

how to formula this in excel?

thanks a lot!
pemt