Posted by Frustrated on August 22, 2001 11:36 AM
I have nine worksheets in a workbook as data sheets for specific manufacturers. Each one lists a product number in column A and price in column J. Each of these sheets is updated at different time throughout the day and week. As a part of a summary work sheet I want the user to be able to enter the manufacturer in A2 and product number in B2. I would like C2 to return the most recent price from the nine other sheets. Is there a way to look this up without combining the 9 data sheets on a daily (or more often) basis and keying a vlookup off that?