I am trying to organize a worksheet so that when I enter a number or text in cell D3 a figure is automatically entered into cell G5, If a number (part number) is entered a value of the part appears in G5.
probably a simple task but I just cant get my head around formulas..
Thanks in advance
You may try this formula in cell G5:=if(D3="","",1), you can replace 1 with what you wish it to be.
You probably need VLOOKUP.
If you can't get your head around formulae, is Excel the place you want to be?
Ed
_____________________________
Always learning, but never enough!
_____________________________
Thanks JJW...
Your right Ed.. lots of places I'd rather be than in excel or on the computer for that matter..lol
I have started a new business, just trying to keep track of work done, parts fitted and their value.. Its a single person operation and keeping costs down.
Thanks Ed..
oh.. Exeter.. nice Place.. stayed in Collumpton for a while a few years ago..
Hi Jeff,
Do you want to post an example of what you want to achieve and I'll see what I can do?
Ed
_____________________________
Always learning, but never enough!
_____________________________
Thanks Ed..
If any of the items listed in column D is entered the corresponding value appears in column G..
Hi Jeff
see the attached - I have done it in 2003 as I don't have 2007 but should be fine.
I have put some notes in to explain.
Post back if you need more help
Regards
Ed
_____________________________
Always learning, but never enough!
_____________________________
Thanks Ed...
not long finished a 15hr day... the 20th in a row.. I'll enter that tomorrow when the brain thinking a little better... THANKS....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks