Excel Help

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

I'm having a little problem trying to work out how to get excel to query 2 worksheets and return unmatched/Orphan records

Setup

WS1 - Invoices
WS2 - Deliveries
WS3 - NoDeliveries

i want to display only records that have an invoice but no matching delivery. I would appreciate an help on this matter as my excel knowledge isn't upto much ;)

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

found a formular that give me the results i was looking for

Code:

=IF(ISNA(MATCH(K185, Deliveries!U$1:Deliveries!U$2000, 0)), "NDN", "Found")

Thanks