Compare workbooks&highlight conditional match

Solved/Closed
PM - Jun 28, 2011 at 11:07 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Jul 5, 2011 at 12:14 AM
Hello,

I am having 2 works sheets.

First "order" book ,which is not having Invoice no and date.( cloumn B & C)


second book "invoice" having additional details of Invoice no. & date, these columns will be empty in ''order'' book.. Few additional rows also will be found in this sheet, which may not found in "order"


i need to compare these 2 books and results, if any rows in "order " book having values in column B & C in " INVOICE" book will be shown in separate third book.


sample enclosed.
http://www.speedyshare.com/files/29192449/ORDER.XLS
http://www.speedyshare.com/files/29192459/INVOICE.xls

Please help. Many thanks in advance.

Related:

4 responses

RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Jun 30, 2011 at 02:36 AM
we can Vlookup on some unique reference or a combination of references which are unique.

but as looking on your files we don't have unique reference or combination of reference which leads to wrong result.
Thanks for response. You are right.

What if suppose column B having unique references. pl. see this.
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Jul 1, 2011 at 06:51 AM
If in B column Invoice no. is unique reference.

then you can map these two files using Vlookup and put invoice date (Column C) from Order file.

the formula is as:

=Vlookup (B2,[Ordersheet.xls]Sheet1!$B:$C,2,false)

now filter and get the required result.
Hi.

Many thanks for the formula.
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Jul 5, 2011 at 12:14 AM
You are most welcome