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
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Jul 5, 2011 at 12:14 AM
Related:
- Compare workbooks&highlight conditional match
- Music match jukebox - Download - Audio playback
- Beyond compare download - Download - File management
- "Compare versions word" - Guide
- Conditional formatting if cell contains text ✓ - Excel Forum
- Partial match excel - Guide
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
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.
but as looking on your files we don't have unique reference or combination of reference which leads to wrong result.
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Jul 1, 2011 at 06:51 AM
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.
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.
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Jul 5, 2011 at 12:14 AM
Jul 5, 2011 at 12:14 AM
You are most welcome
Jun 30, 2011 at 08:05 PM
What if suppose column B having unique references. pl. see this.