RE: 1=City, 2=Roskill

Steved

You can only have 7 nested ifs. To get more your best bet would probably be
to use a Vlookup with a refrence table. Set the table up like this
1 City
2 Roskill
etc

My reference table is in range I1 to J9 so then the vlookup would be
something like:
=VLOOKUP(--LEFT(A1),$I$1:$J$9,2,0)

See http://www.contextures.com/xlFunctions02.html for more details on Vlookups

Regards
Rowan

"Steved" wrote:

> Helllo Rowan from Steved
>
> Question please
> =IF(LEFT(F6)="1","City",IF(LEFT(F6)="2","Roskill",IF(LEFT(F6)="3","Papakura",IF(LEFT(F6)="4","Wiri",IF(LEFT(F6)="5","Shore",IF(LEFT(F6)="6","Orewa",IF(LEFT(F6)="7","Swanson","")))))))
>
> I would like to add 2 more in ie
> IF(LEFT(F6)="8","Panmure",IF(LEFT(F6)="9","Waiheke",
>
> With your formula you kindly gave me is it possible.
>
> Thankyou.
>
> "Rowan" wrote:
>
> > =IF(LEFT(A1)="1","City",IF(LEFT(A1)="2","Roskill",""))
> >
> > Regards
> > Rowan
> >
> > "Steved" wrote:
> >
> > > Hello from Steved
> > >
> > > I would like to please use only the first number as a identifier.
> > >
> > > for example 1234, 1543, 1789, 1673 in this case the 1 will = City
> > > for example 2234, 2543, 2789, 2673 in this case the 2 will = Roskill
> > >
> > > Thankyou.
.

Relevant Pages

  • Re: calculating after vlookup
    ... > antonov wrote: ... >> is it possible to calculate the result of a vlookup * the value of ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Lookup Not working as expected
    ... >> As far as I know, LOOKUP only works correctly if the lookup range is ... >> Regards, ... I tried using VLOOKUP and HLOOKUP but I seem to get ... > contents of the cell beside the cell that contains the lowest value, ...
    (microsoft.public.excel.newusers)
  • Re: Summing vlookups?
    ... You can still do it, assume the named range is MyTable, then use ... Regards, ... > the Vlookup and it changes. ... > that the column to sum will change. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: addon to equation
    ... "Peo Sjoblom" wrote: ... > It doesn't make any sense to use a vlookup formula to test for a match, ... >>> Regards, ... >>> (No private emails please) ...
    (microsoft.public.excel.misc)
  • Re: why doesnt vlookup function work?
    ... The False or 0 needs to be used as the 4th argument in the Vlookup ... Regards ... Roger Govier ...
    (microsoft.public.excel)