Prev: V Lookup and Multiple Values
Next: Sum Formula dilemma - Can yu Solve?
From: sagenichole on 17 May 2010 17:14
Ok I am trying to make the document where if I enter "a" in one cell, the
cell next to it will auto populate a given value that I define. Please let me
know how I can do this!!!

Thanks!!!
From: Pete_UK on 17 May 2010 17:21
If you have a table of values somewhere which determines what "a" is
equivalent to, then you could use a VLOOKUP formula in the next cell.

Hope this helps.

Pete

On May 17, 10:14 pm, sagenichole
<sagenich...(a)discussions.microsoft.com> wrote:
> Ok I am trying to make the document where if I enter "a" in one cell, the
> cell next to it will auto populate a given value that I define. Please let me
> know how I can do this!!!
>
> Thanks!!!

From: Ron on 18 May 2010 08:40
With the limited information in your question the following will give you a
solution:
Cell A1 is where you enter "a"
Cell A2 is the given value that you define
Cell A3 contains the formula =IF(A1="a",A2,"")
Change the cell references to suit your lay out.
Hope this helps

"sagenichole" wrote:

> Ok I am trying to make the document where if I enter "a" in one cell, the
> cell next to it will auto populate a given value that I define. Please let me
> know how I can do this!!!
>
> Thanks!!!
From: Gord Dibben on 18 May 2010 14:33
Enter in B1

=IF(A1="","",LOOKUP(A1,{"a","b","c","d","e","f"},{1,2,3,4,5,6}))


Gord Dibben MS Excel MVP

On Mon, 17 May 2010 14:14:05 -0700, sagenichole
<sagenichole(a)discussions.microsoft.com> wrote:

>Ok I am trying to make the document where if I enter "a" in one cell, the
>cell next to it will auto populate a given value that I define. Please let me
>know how I can do this!!!
>
>Thanks!!!

 | 
Pages: 1
Prev: V Lookup and Multiple Values
Next: Sum Formula dilemma - Can yu Solve?