Re: $$Excel-Macros$$ ARRAY FORMULA TAKE MORE TIME

2012-01-04 Thread Aamir Shahzad
You also can use Offset for Invoice =OFFSET($H$1,MATCH(A32,$H$1:$H$16,0),-5) for data =TEXT(OFFSET($H$1,MATCH(B32,$H$1:$H$16,0),-7),"m/dd/") Regards, Aamir Shahzad On Wed, Jan 4, 2012 at 8:32 PM, NOORAIN ANSARI wrote: > Dear chandra, > > You can also use VLookup... > > *=VLOOKUP($

Re: $$Excel-Macros$$ ARRAY FORMULA TAKE MORE TIME

2012-01-04 Thread NOORAIN ANSARI
Dear chandra, You can also use VLookup... *=VLOOKUP($A32,CHOOSE({1,2},$H$2:$H$16,$C$2:$C$16),2,0)* See attached sheet.. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ ARRAY FORMULA TAKE MORE TIME

2012-01-04 Thread chandra sekaran
ailto: > excel-macros@googlegroups.com] *On Behalf Of *chandra sekaran > *Sent:* Jan/Wed/2012 08:09 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ ARRAY FORMULA TAKE MORE TIME > > ** ** > > Dear all, > > > > do you sugguest

RE: $$Excel-Macros$$ ARRAY FORMULA TAKE MORE TIME

2012-01-04 Thread Rajan_Verma
You can use this Simple Function: =INDEX($A$1:$I$16,MATCH(A32,$H$1:$H$16,0),1) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of chandra sekaran Sent: Jan/Wed/2012 08:09 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ ARRAY FORMULA TAKE MORE

$$Excel-Macros$$ ARRAY FORMULA TAKE MORE TIME

2012-01-04 Thread chandra sekaran
Dear all, do you sugguest any other formula is there . [ MY Formula sheet attached] Regards durai.chandra sekaran.(Chandru) -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Pro