Prev: Help with SumProduct
Next: Using a cell's value to copy another cells info to another workshe
From: Joodle on 16 Mar 2010 22:03
That's it! Thanks. I was trying to make it so much more complicated!

"Teethless mama" wrote:

> In B1: =IF(A1=1,"Apple","")
> In C1: =IF(A1=2,"Banana","")
> and so on...
>
>
> "Joodle" wrote:
>
> > I want to lookup a value in a table, then return a value to a different
> > column based on the result.
> >
> > For example:
> >
> > Sheet 1 has:
> >
> > col A
> > ------
> > 1
> > 2
> > 3
> > 4
> >
> > Sheet 2 (LOOKUP table) has:
> >
> > col A col B
> > ------ ------
> > 1 Apple
> > 2 Banana
> > 3 Carrot
> > 4 Date
> >
> > I want to write a formula in sheet 1 that says:
> >
> > if the value in col A is 1, enter Apple in col B
> > if the value in col A is 2, enter Banana in col C
> > if the value in col A is 3, enter Carrot in col D
> > if the value in col A is 4, enter Date in col E
From: Teethless mama on 16 Mar 2010 22:26
You're Welcome!


"Joodle" wrote:

> That's it! Thanks. I was trying to make it so much more complicated!
>
> "Teethless mama" wrote:
>
> > In B1: =IF(A1=1,"Apple","")
> > In C1: =IF(A1=2,"Banana","")
> > and so on...
> >
> >
> > "Joodle" wrote:
> >
> > > I want to lookup a value in a table, then return a value to a different
> > > column based on the result.
> > >
> > > For example:
> > >
> > > Sheet 1 has:
> > >
> > > col A
> > > ------
> > > 1
> > > 2
> > > 3
> > > 4
> > >
> > > Sheet 2 (LOOKUP table) has:
> > >
> > > col A col B
> > > ------ ------
> > > 1 Apple
> > > 2 Banana
> > > 3 Carrot
> > > 4 Date
> > >
> > > I want to write a formula in sheet 1 that says:
> > >
> > > if the value in col A is 1, enter Apple in col B
> > > if the value in col A is 2, enter Banana in col C
> > > if the value in col A is 3, enter Carrot in col D
> > > if the value in col A is 4, enter Date in col E
First  |  Prev  | 
Pages: 1 2
Prev: Help with SumProduct
Next: Using a cell's value to copy another cells info to another workshe