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