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.
|