Form for search pages by meta datas

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';
}
?>