ros$$ Re: How can I match two different data, where
> only a reference number and amount are common.
>
>
> Kindly find the attached excel work book and possibly assist. i need to
> match all the data of the first sheet to the outstanding in the second sheet
>
> On M
Hi,You can use VLOOKUP. For more how to use VLOOKUP check..Microsoft office help.Sandeep.
sorry i forgot to attach, this is the attachement
On Monday, March 30, 2015 at 3:49:00 PM UTC+3, Saddam Ali wrote:
>
> Kindly find the attached excel work book and possibly assist. i need to
> match all the data of the first sheet to the outstanding in the second sheet
>
> On Monday, March 30, 20
Kindly find the attached excel work book and possibly assist. i need to
match all the data of the first sheet to the outstanding in the second sheet
On Monday, March 30, 2015 at 12:37:28 PM UTC+3, Saddam Ali wrote:
>
> My name is Baricha, from Kenya. I work in a bank and so i cannot upload
> the
Hello
In both sources add column where you join ref nb and amount like=A1&b1
(where for example in A is ref nb and B ammount) . Then you can use vlookup
cos the possibility, I suppose, to non unique values are very small. Do not
matter what is the result of given formula, the only witch matters