Need Formula to Display the values not found using vlookup

I have two columns containing numbers and have done a vlookup to see if the values exist in each column. Now I need a formula to return the numbers that were NOT found using the vlookup function.

Hi,

Could you please upload your workbook?

Thanks

My apologies. I don't know how to upload it.

No worries.

Click "Go Advanced", then "Manage Attachments" and find the file to upload

Oh, thanks! Here's the attachment.

Just to confirm, do you want to know which values are in R but not in P? Or the values in P but not in R? Or are you basically after a list of unique values from both of these columns combined?

Let me provide more details: I am running queries from two different sources, then placing them in Excel. Both sources contain ID values. I need to compare the ID values that exist in R and not P as well as exist in P and not R. If the vlookup does not find a matching ID then I need it to display the name associated to the ID. I have uploaded a new file with name column. My apologies that this question has probably been asked, but I have spent too much time trying to figure out the Excel formula and could realy use the help. Thanks.

This might be better achieved with VBA, but here is a solution using only Excel functions and formulas, with a number of hidden columns, as this is not in the VBA section of the forum.

The list that I understand you are trying to extract is in column H. The formula refers to cells in the hidden columns F and G, which contain formulas referring to the hidden columns D and E. Feel free to look over the formulae in these hidden columns if you would like to understand what is going on here.

I hope this helps

Thanks for your time. I am not too familiar with the match and index functions in Excel. I would probably understand this better in VBA. (I should have posted it there.) I will work on accomplishing in VBA since I have to reconcile this data quarterly. Ultimately want to run the queries from both data sources and dump into data sheets in excel, then refresh the formulas or re-run the macros, etc. My problem would be solved!

No problems.

I have added a VBA solution for you, on the "VBA" worksheet. Note that it gives a different solution to my previous Excel formula solution. I have since discovered that my Excel formula solution was incorrect.

I hope this helps

If this solves your problem, please don't forget to mark this thread as solved, and please click on the * next to my post to say thanks

I definitely want to take a look. Did you upload another file?

Maybe with formula can work it out, please see the file

Thanks