Formula - Looking up Two Values to Return One

Occasional Contributor

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. 

10 Replies


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.

Thank you!


You need to share the workbook - I currently get this:


try access it should work!


Thanks, got the workbook. What do you want to compare to what?

Great! I am trying to tell Excel; to tell me if the budget on sheet 2 matches with the budget on sheet one based on the MPA#. And then calculate the variance between budget on sheet 1 vs sheet 2.
Hope this makes sense!


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?

Yes, sorry i tried to copy this just to use as an example. I can add the same data to make it a bit easier to see if everything works.


In N2 on Sheet1: =VLOOKUP(A2,Sheet2!$A$2:$B$5,2,FALSE)

In O2: =M2-N2

Fill down.

my apologies for the delay, but thank you so very much for your help on this! Much appreciated!