|Posted: March 22, 2011, 2:58 am - IP Logged|
I really need some Excel help. Can someone help me?
I'm not a "formula" person and after going online to teach myself, i haven't been able to find the right formula for the job i need done. I'm working on a system for pick 4.
This is what i have so far:
When i fill in the top cell, i have it designed that 3 of the bottom cells fill to match 3 of the top cells automatically. After this, i have difficulty.
I'd like to make a formula that will produce (in this case) the sister number (the vtrac) of "6", which is "1" , in the empty cell beneath "6" when the top cell fills with a number . I've tried "IF" and "Lookup" and still i get errors. Can someone help me with this?
P.S.-I hope i explained it well enough. I'm not too familiar with programming jargon. Thanks again!!!!!
It's better to ask for permission than to beg for forgiveness.