Setting up an auto fill cell

  • Thread starter Thread starter intheway
  • Start date Start date
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
 
Create a lookup table: right column = 2 digit code, left
column = corresponding autofill value.
Populate C cells with vlookup formulae.
Patrick D.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate (Auto Fill) cells with numbers and text. 3
How can I transpose reference cells by Auto-fill? 3
Change Default Auto-Fill-In month 4
Calculating Average based on 3 filled cells from left in a row 6
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
auto fill options (copy cell, not create series) 4
VLOOKUP & IF or Sumproduct 7
Excel 2007 auto fill help 1

Back
Top