Identifying non-pulled data from Vlookups

[rhyan66]

Good afternoon everyone and thanks in advance for your help!

I have a master file that lists a variety of data and requires updating from various reference reports. Every month, reference reports detail activity (Revenue) that is processed for most of the existing rows on the master file (previously listed Jobs) in addition to activity for new rows (New Jobs) that are not listed in the master file.

I know I can execute a Vlookup to look up the activity for the existing job, but I still need to comb through the data to see which jobs need to be added to the master file. Is there a function that will note which row from the reference sheet were not pulled and therefore should be added to the master file?

Sorry in advance if previously posted.

Ryan

[NBVC]

Maybe something like:

=ISNUMBER(MATCH(A1,'Sheet1'!A:A,0))

where A1 is the first item in your report file and Sheet1!A:A is column to compare to in Master file. If the item does not appear, it returns FALSE.

[rhyan66]

Thank you, definitely not something I'd of come with on my own. I do seem to be running into an issue since they are all true.

Here is the formula: =ISNUMBER(MATCH(B206,$B$2:$B$199))

If I understand correctly, the red is looking up my reference file and the blue is comparing the red to a range that is my entire master file, correct?

[NBVC]

Yes, correct... the red is the item you want to find in the blue range.... but you need the last ,0 in the MATCH function to ensure an exact match is found.

=ISNUMBER(MATCH(B206,$B$2:$B$199,0))

[rhyan66]

Thanks - "0" is key!!!