Take a look at https://developer.wordpress.org/reference/classes/wpdb/get_col/
On your result page, receive the query as follows
<?php
if(isset($_POST['name']) || isset($_POST['email'])){
$name="%" . $wpdb->esc_like( $_POST['name'] ) . '%';
$email="%" . $wpdb->esc_like( $_POST['email'] ) . '%';
global $wpdb;
$prepare = $wpdb->get_col( $wpdb->prepare( " SELECT post_id FROM ".$wpdb->prefix."postmeta AS M WHERE M.meta_value LIKE '%s' OR M.meta_value LIKE '%s' ", $name, $email ) );
$post_ids = array_unique($prepare);
$search = array(
'post_type' => 'any',// or your post type
'post__in' => $post_ids,
'post_status' => array('publish','private','future'),//or only 'publish'
'nopaging' => true,
'orderby' => 'title',
'order' => 'ASC',
'cache_results' => false,
);
$result = new WP_Query($search);
if($result->found_posts >= 1){
while($result->have_posts()) : $result->the_post();
global $post;
//$permalink = get_permalink($post->ID);//If necessary
echo get_post_meta( $post->ID, 'name', true).', ';
echo get_post_meta( $post->ID, 'email', true).'<hr>';
endwhile;
wp_reset_postdata();
}else{
echo 'Nothing here';
}
}else{
echo 'Error: Fill the name or email';
}
?>