MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Aladin quick questions


Posted by Daniel Cremin on February 12, 2002 3:52 AM

Dyou know ne thing about 1-2-3. I dont want to use it but i need to know if it could meet certain needs

Bascially i need to know the following:
~Does it have the following functions - LOOKUP, VLOOKUP, INDEX, COUNTIF and what are they called
~Does it support VBA


Posted by Aladin Akyurek on February 12, 2002 4:45 AM

VLOOKUP: @VLOOKUP
LOOKUP: -
INDEX: @INDEX
COUNTIF: - (It seems @SUMPRODUCT is used also when COUNTIF needed.)

I don't about VBA. If it supports VB, it will I expect differ somewhat from that supported by Excel.

=============

Posted by Aladin Akyurek on February 12, 2002 10:03 AM

Addendum

According to Walkenbach it has also @COUNTIF, equivalent of COUNTIF.