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.

4 replies

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.
0
Thanks for response. You are right.

What if suppose column B having unique references. pl. see this.
0
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.
0
Hi.

Many thanks for the formula.
0
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
0