This copy to unsubscribed OP:
DET
DougT wrote:
Erick Ruiz Richter wrote:
Dear Sir.
i send a Sheet calc with a HLOOKUP ejample, I think that is imposible
select more column that 13.
Thank you,
I think that your job is very good.
You need to include the "sort order" parameter (=false, in this case),
to get the result you are looking for. For example, when the formula in
Q22 is
=HLOOKUP(Q$10;$D$10:$S$16;$B$22;0) instead of only
=HLOOKUP(Q$10;$D$10:$S$16;$B$22) as you have it entered, the value
returned is "A".
hth,
DougT
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]