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 isk1...@gmail.com 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*
-
From: Pravin Gunjal isk1...@gmail.com
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
Look up value
