Hello ,
In case you have to files .xls and .xlsx you have to make formula with
Insert Function ( ALT + I + F ).
instead of write =vlookup or =lookup
give it a try.
On Tuesday, July 10, 2012 12:23:47 PM UTC+3, Bhaity wrote:
Hi Experts,
i am getting error in vlookups in finding the
Thanks Ji,but could you please solve in the sheet.
Thanks Regards,
*Deba Ranjan P*
On Tue, Jul 10, 2012 at 4:08 PM, CoRe neculae.vale...@gmail.com wrote:
Hello ,
In case you have to files .xls and .xlsx you have to make formula with
Insert Function ( ALT + I + F ).
instead of
Hi Deba,
Anil Solution is nice
you can also use below formula without using Ctrl+shfit+Enter
=LOOKUP(2,1/(SUBSTITUTE(SalarySheet!$A$2:$A$146, ,)=SUBSTITUTE($B2,
,)),SalarySheet!$D$2:$D$146)
On Tue, Jul 10, 2012 at 4:56 PM, Anil Gawli gawlianil8...@gmail.com wrote:
Dear devaran,deba,neculae