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!!!