Prev: Help with SumProduct
Next: Using a cell's value to copy another cells info to another workshe
From: Joodle on 16 Mar 2010 16:15
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: Eva on 16 Mar 2010 16:44
Hi
The formula
=VLOOKUP(A1,Sheet2!A:B,2,FALSE)
--
Please click "yes" if this post helped you!

Greatly appreciated

Eva


"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: Joodle on 16 Mar 2010 19:02
This formula placed all the results from the lookup in the same column.

I want the results such that all "Apple" are in col B, all "Banana" are in
col C, all "Carrot" are in col D, and all "Date" are in col E.

"Eva" wrote:

> Hi
> The formula
> =VLOOKUP(A1,Sheet2!A:B,2,FALSE)
> --
> Please click "yes" if this post helped you!
>
> Greatly appreciated
>
> Eva
>
>
> "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:
> >

From: Eva on 16 Mar 2010 19:21
Hi
I don't know what you want to accomplish, but try this
=TRANSPOSE(VLOOKUP($A2,Sheet2!$A:$B,2,FALSE))
(it is array formula ctrl+shift+enter)
--
Please click "yes" if this post helped you!

Greatly appreciated

Eva


"Joodle" wrote:

> This formula placed all the results from the lookup in the same column.
>
> I want the results such that all "Apple" are in col B, all "Banana" are in
> col C, all "Carrot" are in col D, and all "Date" are in col E.
>
> "Eva" wrote:
>
> > Hi
> > The formula
> > =VLOOKUP(A1,Sheet2!A:B,2,FALSE)
> > --
> > Please click "yes" if this post helped you!
> >
> > Greatly appreciated
> >
> > Eva
> >
> >
> > "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:
> > >
>
From: Teethless mama on 16 Mar 2010 21:20
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
 |  Next  |  Last
Pages: 1 2
Prev: Help with SumProduct
Next: Using a cell's value to copy another cells info to another workshe