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 wrote:
> Dear devaran,deba,neculae
> Just see the a
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 wrote:
> 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 =
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