dattagal
09-22-2006, 12:08 PM
THis is probably very simple for someone who knows how to do it but I am about to pull my hair out.
I searched help in Excel and this forum and cannot find what I need so I am going to post.
I have two columns in one sheet (POD Order Detail) that have an order number and a subtotal. The order number is repeated in another sheet and I want Excel to look up the order number in POD Order Detail and populate (ColJ) with the subtotal that corresponds with the POD Order Detail order number.
For example, in POD Order Detail I have an order number column (B) and in column (E) there is a subtotal.
In DailyStatusRpt I have the order number again (column A) and I want Excel to look up the subtotal in POD Order Detail that Corresponds with that same order number in POD Order Detail and put it in Column J.
:banghead: I hope this makes sense.
Ergh!!! If I could just use Access!!! I don't know Excel very well.
I would appreciate your help tremendously.
I searched help in Excel and this forum and cannot find what I need so I am going to post.
I have two columns in one sheet (POD Order Detail) that have an order number and a subtotal. The order number is repeated in another sheet and I want Excel to look up the order number in POD Order Detail and populate (ColJ) with the subtotal that corresponds with the POD Order Detail order number.
For example, in POD Order Detail I have an order number column (B) and in column (E) there is a subtotal.
In DailyStatusRpt I have the order number again (column A) and I want Excel to look up the subtotal in POD Order Detail that Corresponds with that same order number in POD Order Detail and put it in Column J.
:banghead: I hope this makes sense.
Ergh!!! If I could just use Access!!! I don't know Excel very well.
I would appreciate your help tremendously.