ur name range (PDATA) shud start frm col B and not from col A.i.e. from col B
to
col F or may b more if u like. so the new formula will b
=VLOOKUP(K13,PDATA,5,FALSE)
formula without name range.
=VLOOKUP(I18,$B$2:$F$3,5,FALSE)
this will solve the problem
>
>From: SAJID MEMON
>To: Excel Group
Hi Sajid,
First of all, your sheet is protected, I couldnt save it as.. and 2nd you
are using wrong formulas.. specially which naming the range.
In the form sheet you are trying to do vlookup on a blank source.. in the
last sheet you are using a wrong name range for Vlookup..
We need an unprotec
Done...!!!
Best Regards,
DILIPandey
On 11/27/10, SAJID MEMON wrote:
>
> Dear All Experts,
>
> My doubt is attached, please co-operate me for accomplish my project.
>
> awaiting your positive responce
>
> Regards,
>
> Sajid Memon.
>
>
> --
> -
add this macro to delete button
Sub deletedump()
Sheets("Dump").Range("a1:D65356").Clear
End Sub
On Sat, Nov 27, 2010 at 5:49 PM, SAJID MEMON wrote:
> Dear All Experts,
>
> My doubt is attached, please co-operate me for accomplish my project.
>
> awaiting your positive responce
>
> Reg
