Dear ,
I am developing accounting database on excel for a distribution network .I am
facing problem to calculate cogs of different product .If some one has already
make such report on excel plz share .
I have one master sheet in which all purchase and sales is recorded on the
basis of this sh
Dear Friends,
I have attached Workbook here with the name of call history. Which has two
sheets Contacts and Call History,
Now I want to Look up Names from Contacts Sheet & Display Name in an other
sheet named call history.
Your help in this regard will be highly appreciated.
Thanks in Advance
plz find attached .
Date: Sun, 27 Oct 2013 21:27:29 +0500
Subject: $$Excel-Macros$$ Look up Names from Contacts Sheet & Display Name in
an other sheet named call history.
From: imrafiqu...@gmail.com
To: excel-macros@googlegroups.com
Dear Friends,
I have attached Workbook here with the name of
hi.
Plz find solution using vlookup with choose.
regards,
Ashwani
On Mon, Oct 28, 2013 at 1:36 AM, Kashan Abbas wrote:
> plz find attached .
>
> --
> Date: Sun, 27 Oct 2013 21:27:29 +0500
> Subject: $$Excel-Macros$$ Look up Names from Contacts Sheet & Display Name
>
PFA OR
=IFERROR(VLOOKUP(A2,CHOOSE({1,2},Contacts!$B$2:$B$13,Contacts!$A$2:$A$13),2,
0),"UNKNOWN NUMBER")
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of M.Rafique MRU
Sent: Sunday, October 27, 2013 9:57 PM
To: excel-macros
Subject: $$Excel-Macros$$ L