Pivot tbl & Lookup function Help

O

Os

I need to setup a formula outside my pivot table to do
the following:
I have two columns in the pivot table marked "Y" for
yes,and "N" for no. If the item showing qty under "N" I
want to lookup that item and get the days of the week
that matches "Y" from a list in another sheet.
Basically, i'm trying to show the correct ordering days
next to the pivot table, when the customer order on the
wrong day.

Any help is greatly appreciated.

Thanks.
 
J

Jim Buyens

This seems to be an Excel question. Please post it on an Excel newsgroup.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
Top