Lookup Wizard in Excel 2000

[Harley]

My Excel 2000 doesn't have the Lookup Wizard Add-in installed. I can't figure out how to get this wizard installed. I've been on the microsoft website but I can't find this particular add-in. Where can I find it?

 

[Aladin Akyurek]

On 2002-03-18 09:19, Harley wrote:
My Excel 2000 doesn't have the Lookup Wizard Add-in installed. I can't figure out how to get this wizard installed. I've been on the microsoft website but I can't find this particular add-in. Where can I find it?

Did you look at Tools|Add-Ins?

A personal note: Try to avoid those wizards as soon as possible.

 

[Juan Pablo González]

Agree with Aladin. Use them ONCE to know how the really basic basic formula works, and then try to build a good formula from that...

 

[Chris Davison]

Juan Pablo, Aladin,

does that advice include the step-by-step process when you click on the "Fx" button ?

(say, I am using DSUM.... my first port-of-call would be to hit Fx and scroll down to DSUM and take it from there)

((in fact, I still do this for VLOOKUP and I'm 100% comfortable with this function))

!

thanks
Chris

 

[Aladin Akyurek]

On 2002-03-20 12:02, Chris Davison wrote:
Juan Pablo, Aladin,

does that advice include the step-by-step process when you click on the "Fx" button ?

(say, I am using DSUM.... my first port-of-call would be to hit Fx and scroll down to DSUM and take it from there)

((in fact, I still do this for VLOOKUP and I'm 100% comfortable with this function))

!

thanks
Chris

My advice is anchored in the fact that such means delay, even counteracts, absorbing the syntax of the worksheet functions. It's like knowing one's girl friend's phone number versus searching thru one's wallet and taking out a piece of paper in order to make a phone call .

Aladin
This message was edited by Aladin Akyurek on 2002-03-20 13:04