View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LEOPARDSHIDEAWAY LEOPARDSHIDEAWAY is offline
external usenet poster
 
Posts: 7
Default look up last date ordered

I have a spread sheet like this

date item descr qty

9/1/06 56 desc 23
9/5/06 67 desc 100
9/8/06 56 desc 16
9/16/06 10 desc 50
9/5/06 56 desc 100

on another worksheet i have a lsit of item numbers and descriptions

i want to create a column showling last dateordered of item #56, is there a
simple way to do this?