copy a range of data based on one entry

[armyguy]

This may be simple, but I cannot figure it out.

- On worksheet one, I have 3 columns of data in columns A, B and C.
- There are about 2600 rows of data in these columns.
- Column A in these rows all contain serial numbers

- On worksheet two, I have 3 columns for potential data in columns A,B and C.
- In the rows in column A of worksheet two, I will type in one of the serial numbers that is already in one of the cells in column A on worksheet one.
- When I type in that serial number in column A, I would like the data in columns B and C, in the same row as that serial number in worksheet one, to automatically populate columns B and C in the row that I just typed the serial number in worksheet two.

These serial numbers are for items that will arrive at different times. After the data automatically populates B and C, I will put the date it arrives in column D. The data in columns B and C are long strings of alphanumerics. I know they are correct in worksheet one, I want to make sure they stay that way in worksheet two. Thanks in advance for any help you may be able to give me.

[JBeaucaire]

This is called an INDEX(MATCH). Read up here for a more lengthy explanation:
http://www.excelforum.com/excel-gene...ame-row.html#3

On sheet 2 starting in B2 and copied down, use this formula:
=IF($A2="","",INDEX(Sheet1!B:B,MATCH($A2,Sheet1!$A:$A,0)))

Also copy that formula into column C and then copy down. As you type in the A column the matching values from Sheet1 will appear.

[armyguy]

I really appreciate your help. It worked great. I learned a few things in the process as well.