Excuse me sir, BUT ... exactly where did I say "Never" ?<g
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ken Wright" wrote in message
...
Never say Never, you might be surprised ;-)
--
Regards
Ken.......................
"Ragdyer" wrote in message
...
Hey Aladin,
If Ken was Bill Gates and I was Steve Ballmer, believe me ... You'd have
your wish!
But since we're not ... Dream On.<g
--
Regards,
RD
--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!
--------------------------------------------------------------------------
-
"Aladin Akyurek" wrote in message
...
If MS ever implements the additional optional argement for lookup
functions I argued for since eons...
=VLOOKUP(LookupValue,TableX,ColIdx,0,VLOOKUP(Looku pValue,TableY,ColIdx,0,Ret
urnValue)
where ReturnValue is optional, which if omitted defaults to #N/A.
Looks nice, no?
Ken Wright wrote:
LOL - Who needs the second trap? #NA is just as good an indicator
as
anything I could chuck in, and assuming the OP had used that last
argument
of 0 in each of his VLOOKUPs then the formula will return an error
if
the
value doesn't exist in the second table either.
|