Hi Sheelo,

sorry I missed that. It's been made public now.

Thanks,
Peter

"Sheeloo" wrote:

Got this message at the page you mentioned;
"This file is currently set to private. "

VLOOKUP picks up only the first match...

"Piotr (Peter)" wrote:

Dear All,

Below is a link to the file with data I am trying to reconcile. The point
is, I can't find 3 values. You will have noticed that I manually added 2
values that were not found by vlookup.
Frankly all values from Columnd D exist in Column B as identified by vlookup
function. However, there are 3 missing and can't be picked up as they are
probably the same values which appear several times in Column D but not in
Column B.
I suspect that the disparity of 25 555,16 is a combination of some amounts.

Any help appreciated with this reconciliation. I was not able to spot this
at work so am trying to do this at home for tomorrow morning. Is there any
function that looks up repetitive values/number e.g. the same invoice number
in a row or column?

Thanks in advance,

Peter

file hosting website: http://www.mediafire.com/?0y2t4guzjyj