I have 2 spreadsheets which I will refer to as (spreadsheet 1) and (spreadsheet 2). I have values under a row called "name" in spreadsheet 1 that I need to cross reference with spreadsheet 2 within 4 of its sheets as to whether or not those values exists that I referenced in spreadsheet 1 under row "name". ********************************************************** (spreadsheet1) (row) name 1.BAHHBD 2.RTYUWL 3.BKHSLS 4.RIOSLL 5.DKHSLL (spreadsheet2) sheet1, sheet2, sheet3, sheet4 <--search all of these sheets for those values in spreadsheet1 under the row "name" and give back a response of yes or no if they exist in any of those 4 sheets. Any help is appreciated, |
<tbody>
</tbody>