Previous Topic Next Topic

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

Answer 1 / 4
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
PM
Jun 30, 2011 at 08:05 PM
Thanks for response. You are right.

What if suppose column B having unique references. pl. see this.
0
Answer 2 / 4
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
Answer 3 / 4
PM
Jul 1, 2011 at 07:08 AM
Hi.

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

Similar discussions

Ig stories from close friends to public
Darren -
zara -

31 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses
Facebook says that my email doesn't match my facebook email
@@@@@@@@@@@ -
Ambucias -

1 response