If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
PLEASE HELP
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!!! |
#2
|
|||
|
|||
PLEASE HELP
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 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!!! |
#3
|
|||
|
|||
PLEASE HELP
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!!! |
#4
|
|||
|
|||
PLEASE HELP
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 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!!! |
Thread Tools | |
Display Modes | |
|
|