Why use Choose instead of Lookup?

[RSXchin]

I've been trying to wrap my head around the Choose function and its application. I can't think of a reason to use Choose instead of Lookup.

Can anyone give me some good examples instead of links to pages I've probably already not understood?

 

[Ron Coderre]

Here are a couple examples:

Easily referencing different cells based on a user selection in A1:

=CHOOSE(A1,Sheet1!B29,Sheet2!A12,Sheet3!Z14)

Looking up a tax rate on the appropriate table based on a user selection

A1:
=VLOOKUP(B1,CHOOSE(A1,Sheet1!B29:C35,Sheet2!A12:B40,Sheet3!Z14:AA27),2,1)

Does that help?

 

[Jonmo1]

Choose can also be used to trap errors..

If the result of the vlookup is normally numeric
=LOOKUP(9.99999999999999E307,CHOOSE({1,2},0,VLOOKUP(....)))


If the vlookup is expected to return Text, use
=LOOKUP(REPT("Z",255),CHOOSE({1,2},"",VLOOKUP(....)))