Re: $$Excel-Macros$$ Required hep in V Look up formula

2012-08-14 Thread Paul Schreiner
s ever you can.” - John Wesley - From: Pravin Gunjal To: excel-macros@googlegroups.com Sent: Tue, August 14, 2012 8:03:01 AM Subject: $$Excel-Macros$$ Required hep in V Look up formula Dear Friends I have use a v-look up in Sheet 1 from Sheet 2 of the attached file. Please see the Sheet 1

Re: $$Excel-Macros$$ Required hep in V Look up formula

2012-08-14 Thread NOORAIN ANSARI
Dear Pravin, Please use =VLOOKUP(VALUE(A3),Sheet2!$B$1:$C$1886,2,0) On Tue, Aug 14, 2012 at 5:32 PM, Pravin Gunjal wrote: > Dear Friends > > I have use a v-look up in Sheet 1 from Sheet 2 of the attached file. > > *Please see the Sheet 1* > Look up value is available in column *A* > V Look up