Formula when I enter a number or text in cell D3 a figure is automatically entered in

**Jeff-C** · 06-20-2008, 05:01 AM

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

**jjw0418** · 06-20-2008, 06:07 AM

You may try this formula in cell G5:=if(D3="","",1), you can replace 1 with what you wish it to be.

**EdMac** · 06-20-2008, 06:08 AM

You probably need VLOOKUP.

If you can't get your head around formulae, is Excel the place you want to be?

**Jeff-C** · 06-20-2008, 06:55 AM

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

**Jeff-C** · 06-20-2008, 06:56 AM

oh.. Exeter.. nice Place.. stayed in Collumpton for a while a few years ago..

**EdMac** · 06-20-2008, 07:10 AM

Hi Jeff,

Do you want to post an example of what you want to achieve and I'll see what I can do?

**Jeff-C** · 06-20-2008, 07:27 AM

Thanks Ed..
If any of the items listed in column D is entered the corresponding value appears in column G..

**EdMac** · 06-20-2008, 07:42 AM

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