Compare workbooks&highlight conditional matchSolved/Closed

Question

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.

Configuration: Windows 7 / Safari 534.30

RWomanizer · Answer

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.

RWomanizer · Answer

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.

PM · Answer

Hi.

Many thanks for the formula.

RWomanizer · Answer

You are most welcome

Compare workbooks&highlight conditional match

4 replies

Subscribe To Our Newsletter!