Hi Brian,
Yes, it's the same function and takes the same parameters. Calc uses the
semicolon rather than a comma as a delimiter. If you want your model
numbers to retain leading zeros you can format the cell to require six
digits. Or you could precede the number with an apostrophe:
'098367. This forces the format to text.
tc
Brian Parker wrote:
Microsoft excel has a function vlookup ( ) does calc have a similar
function, and if I have a model number like 098367 will calc turn it into
98367 can cost me a lot of money?
Brian Parker
ELECTRONICS DEPARTMENT
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
