i have a problem to create a formula...for example in sheet 'A' in 'column A' I have list three different date..for example:

          A2: 1\1\2005 where B1: tshirt
          A3: 2\1\2005 where B2: jean
          A4: 3\1\2005 where B3: tshirt

then i want to capture the date in sheet 'B' in column A1..here i just want to capture output 'tshirt' only for certain date but in different sheet...how i want to create the formula..can u help me...

Hi,

Im not sure I understand this correctly but let me have a try.

In sheet "B", in cell A1 type:

=IF(Sheet1!B1="tshirt",Sheet1!A2,"")

What this formula does is that it checks cell B1 in Sheet1 on the word tshirt. If B1 = tshirt, then the cell where you type this formula in, gets the value of Sheet1!A2, thus the according date. Copy down this formula to the rest of the cells, and you are done

Hope I understood this correctly

Max