HI ,
not sure but have you tried using the value "true" in vlookup, might as
well work out for you. sorry in advance i am not a pro at it just amateur.
thanks & regars
On Mon, Jun 20, 2016 at 4:59 PM, Paul Schreiner
wrote:
> It works fine on my file.
> However, I noticed in YOUR file, the Calc
It works fine on my file.However, I noticed in YOUR file, the Calculation
option is set to "manual".
(A "Calculate" reminder appears in the Status Bar.You have to hit an F9 to
calculate.
which means, when you copy the formula down the column, it retains the original
value until you recalculate.
Hi Paul,
Thanks for your quick reply, However your suggested formula is not working
correctly it shows "No Record Found" for all the records. Hence request you
to kindly help me on this.
Regards,
On Sat, Jun 18, 2016 at 12:50 AM, Paul Schreiner
wrote:
> You're looking for a function like:
> =
You're looking for a function like:=IFERROR(VLOOKUP(F2,D:D,1,FALSE),"No Record
Found") Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long
Hi Paul,
Please find the details in the attached sheet.
Regards,
Vik
On Fri, Jun 17, 2016 at 5:53 PM, Paul Schreiner
wrote:
> What array are you talking about?
> Your file says:
> "If E2 value is in Array then it should reflect in F
> otherwise count as a not found"
>
> So, since column E is
What array are you talking about?Your file says:"If E2 value is in Array then
it should reflect in F otherwise count as a not found"
So, since column E is labeled as "id", then I suspect you want to look in an
array of ID's.The only other ID heading is column "B" which is "Employee Id"But
those
Please Help me on this _
On Jun 17, 2016 14:43, "vikas khen" wrote:
> Hi Team,
>
> Need your help on finding the value in attached sheet.
>
> Request all of you to kindly help me on this
>
> please find attached sheet for the reference.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
