Originally Posted by chines706

I need help with a lookup formula please!

I have a pivot table. In the table is a list of order numbers. On another sheet, I have the same list of order numbers and also the descriptions to each of them. What formula could I use on the pivot tab to get the order numbers to look up the descriptions for each one? Hope Im not too confusing. Thanks!