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$$
Thanks Ravinder this formula works for me.
Thanks and regards, Rupesh
On Mon, Oct 28, 2013 at 12:20 PM, Ravinder ravinderexcelgr...@gmail.comwrote:
PFA OR
** **
=IFERROR(VLOOKUP(A2,CHOOSE({1,2},Contacts!$B$2:$B$13,Contacts!$A$2:$A$13),2,0),UNKNOWN
NUMBER)
** **
*From:*
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 kashanabbas...@hotmail.comwrote:
plz find attached .
--
Date: Sun, 27 Oct 2013 21:27:29 +0500
Subject: $$Excel-Macros$$ Look up Names from Contacts