Apr 20 2022 05:15 PM - edited Apr 21 2022 07:23 AM
Hello and thank you for your help!
I am looking for a formula that would allow me to look at 2 values in one spreadsheet, lookup those two values in another tab, match it to return to one value to confirm that based on those two values, both of my spreadsheet have the right data.
Spreadsheet for reference.
Apr 21 2022 12:29 AM
You can upload the workbook to a cloud service such as OneDrive, Google Drive, Dropbox or similar. Obtain a link to the uploaded file and post the link in a reply.
Apr 21 2022 07:42 AM
Apr 21 2022 08:04 AM
Apr 21 2022 08:19 AM
Thanks, got the workbook. What do you want to compare to what?
Apr 21 2022 08:52 AM
Apr 21 2022 09:05 AM
In your sample workbook, the MPA # column on Sheet2 contains 4 times the same value, and this value does not occur in the MPA # column on Sheet1, so there are no matches at all. Do I interpret that correctly?
Apr 21 2022 09:32 AM
Apr 21 2022 09:39 AM
Apr 21 2022 04:13 PM