Autofill data from one sheet into another

[aarriiaann]

Hello,

I would like to create sheet1 and sheet2 and create some data in sheet1.
When open sheet2 and i search at A row i want B and C to be filled automatically

SHEET1
sheet1.png

SHEET2
sheet2.png


Book1.xls
Book1.xlsx

Thank You!

[Pete_UK]

Don't attach pictures of your worksheets - attach the Excel workbook itself (suitably sanitised).

Pete

[aarriiaann]

Worksheet added to post

[Aardigspook]

Hi,

On Sheet2 in J9 enter:

Please Login or Register  to view this content.

and in J10 enter:

Please Login or Register  to view this content.

You may need to replace commas , with semi-colons ; dependent on your regional settings.

When you now enter 'Test' in J8, J9 will return 'Value1' and J10 will return 'VT1'. If you enter 'Test2' you'll get 'Value3' and 'VT3', etc.

As this is only 'test' data, you'll probably want to amend the formulae with references to the correct data, so here's how VLOOKUP works:
VLOOKUP(what you're looking up,where the data is stored,which column you want to get a return from).
In this file,
what you're looking up is the value in J8.
where the data is stored is in the range Sheet1!A3:C7 - that is, all the columns containing the data you're looking up and the data you want to find.
which column you want is counted from the first column - the first column contains the data you're checking for (e.g. 'Test') so in this file you want returns from columns 2 and 3. Note that these aren't related to column labels - if the table was in columns DEF, you would still want to use '2' and '3'.

Hope that helps.

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.

[aarriiaann]

Hi,

On Sheet2 in J9 enter:

Please Login or Register  to view this content.

and in J10 enter:

Please Login or Register  to view this content.

You may need to replace commas , with semi-colons ; dependent on your regional settings.

When you now enter 'Test' in J8, J9 will return 'Value1' and J10 will return 'VT1'. If you enter 'Test2' you'll get 'Value3' and 'VT3', etc.

As this is only 'test' data, you'll probably want to amend the formulae with references to the correct data, so here's how VLOOKUP works:
VLOOKUP(what you're looking up,where the data is stored,which column you want to get a return from).
In this file,
what you're looking up is the value in J8.
where the data is stored is in the range Sheet1!A3:C7 - that is, all the columns containing the data you're looking up and the data you want to find.
which column you want is counted from the first column - the first column contains the data you're checking for (e.g. 'Test') so in this file you want returns from columns 2 and 3. Note that these aren't related to column labels - if the table was in columns DEF, you would still want to use '2' and '3'.

Hope that helps.

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.

Thank You! This solved my problem.

[Aardigspook]

You're welcome.

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.