P
Paul Corrado
I think this would work. Since choose would require an
input of 1,2,3,4..... you could use a lookup table instead
and return the value with a VLOOKUP formula.
The table would look like this:
1 "One"
2 "Two"
3 "Three"
4 ......
And with the table in A1:B4 the Formula would be:
=VLOOKUP(G4,A1:B4,2,false)
HTH
PC
input of 1,2,3,4..... you could use a lookup table instead
and return the value with a VLOOKUP formula.
The table would look like this:
1 "One"
2 "Two"
3 "Three"
4 ......
And with the table in A1:B4 the Formula would be:
=VLOOKUP(G4,A1:B4,2,false)
HTH
PC