Help Creating a Function in Excel

[kmatthews]

I'm trying to do something in Excel and I can't figure it out - maybe
it can't do it ... I have a spreadsheet with a list of calculated ages
.... I'm trying to get a new column to automatically show the word
"navigator" if the age in R8=6,7,8,9 but if the age in R8=10,11,12 I
want the new column to show "The Edge"

Any help would be appreciated ...

km

 

[RichardSchollar]

Hi

Possibly something like:

=LOOKUP(R8,{0,"";6,"Navigator";10,"The Edge"})

Hope this helps!

Richard

 

[CLR]

=LOOKUP(R8,{0,6,10,13},{"","Navigator","The Edge",""})

Vaya con Dios,
Chuck, CABGx3