Compare workbooks&highlight conditional match
Solved/Closed
PM
-
28 Jun 2011 à 11:07
RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 - 5 Jul 2011 à 00:14
RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 - 5 Jul 2011 à 00:14
Related:
- Compare workbooks&highlight conditional match
- Beyond compare - Download - File management
- Music match jukebox - Download - Audio playback
- How to merge and compare two excel files - Guide
- Csgo custom match commands - Guide
- Tinder match disappeared - Guide
4 responses
RWomanizer
Posts
365
Registration date
Monday 7 February 2011
Status
Contributor
Last seen
30 September 2013
120
30 Jun 2011 à 02:36
30 Jun 2011 à 02:36
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 7 February 2011
Status
Contributor
Last seen
30 September 2013
120
1 Jul 2011 à 06:51
1 Jul 2011 à 06:51
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 7 February 2011
Status
Contributor
Last seen
30 September 2013
120
5 Jul 2011 à 00:14
5 Jul 2011 à 00:14
You are most welcome
30 Jun 2011 à 20:05
What if suppose column B having unique references. pl. see this.