To me, if you just want to "match" the simplest option would be to use a
pivot table. Copy all you ledger numbers in a column. put the locations in
another and draw a pivot.
Attached is an example.
HTH
On Fri, Apr 29, 2016 at 11:39 PM, Cute Awesome
wrote:
> Dear All,
> I'm unable to have exact
Dear All,
I'm unable to have exact match in vlookup for example
in bank ledger 750 was entered five times where as in HO ledger
only 3 times but unable to show it as missing.
The same is the case in HO ledger 800 is twice whereas in bank
ledge its thrice.
Pls help in by suggesting proper way to d