Auto-entering data from another sheet

  • Thread starter Thread starter Lupo
  • Start date Start date
L

Lupo

Hello all,

Hopefully someone can help me.

I am wanting to automatically enter data from one sheet into the next
by a text prompt. For example:

On sheet 2 I will have 3 static columns that will have data entered in
the format: text / text / number respectively.

On sheet one I want to be able to enter the text from the first column
on sheet two and have excel automatically fill in 2 other cells with
the data from cell B and C from sheet 2.

For example:

Sheet 2 contains hello / how / 123 in row 1 and column A,B,C.

I enter: hello (on sheet 1 cell A) and in cell B and C I automatically
get how / 123 automatically

Can this be done?!?!

Please help
 
Lupo,

On sheet1 un cell B1 put the formula :
VLOOKUP(A1,Sheet2!$A$1:$C$100,2,0)

and in cell C1 (on sheet1) put :
VLOOKUP(A1,Sheet2!$A$1:$C$100,3,0)

This is set up on the assumption that you enter your hello in cell A1 on
sheet1 and that the static columns in sheet2 range fron A1 to C100

Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top