Setting up an auto fill cell

I

intheway

I need to set up some kind of auto fill cell where the end user enters
two digit code in cell b1-b150 and excel will auto fill the dollar valu
associated with the code in cells c1-c150.

Your help will be very appreciated

Thank yo
 
P

plduong

Create a lookup table: right column = 2 digit code, left
column = corresponding autofill value.
Populate C cells with vlookup formulae.
Patrick D.
 
I

intheway

Ok I really goofed - insterad of replying, I posted a new thread - sorr
guys. I know the norm is to not add attach(s), but it is the only wa
that I can show u what happened. The formula worked great for som
codes, but not for others???

Again - thanks for all of ur hel

Attachment filename: hourstemplate2.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=69675
 
Top