Excel Formula Help

[jacke613]

This is what I need to do...
I have 1 sheet with a bunch of order numbers, and the info for that order in the row.
example:
12345 customer qty date
13213 customer qty date

Now I want to make a new sheet where I can type in the order # (12345 or 13213) and have it automatically fill in the information automatically (customer, qty, date).

Please help!

Thanks!
Jack

[k2extrem5]

email me and I will send you the attachment with the solution. [email protected]

[BenjieLop]

This is what I need to do...
I have 1 sheet with a bunch of order numbers, and the info for that order in the row.
example:
12345 customer qty date
13213 customer qty date

Now I want to make a new sheet where I can type in the order # (12345 or 13213) and have it automatically fill in the information automatically (customer, qty, date).

Please help!

Thanks!
Jack

On your new sheet, it is assumed that your order number will be typed in Column A, starting from Cell A1 (and going down). It will also be assumed that your data range in Sheet 1 is A1:D100.

This being said, enter the following formula in:

Cell B1: =vlookup(A1,Sheet1!$A$1:$D$100,2,0)

and this will give you your "customer" that corresponds to the "order number" that you entered in Cell A1;


Cell C1: =vlookup(A1,Sheet1!$A$1:$D$100,3,0)

and this will give you your "qty" that corresponds to the "order number" that you entered in Cell A1;


Cell D1: =vlookup(A1,Sheet1!$A$1:$D$100,4,0)

and this will give you your "date" that corresponds to the "order number" that you entered in Cell A1;

Copy down all your formulas until your requirements are met.


Hope this will help you. Regards.