Search results

  1. L

    VLOOKUP- table_array-HELP!!!

    Someone sent me a workbook with a VLOOKUP and I thought maybe I could do something else with it. In sheet 1 you would request what is the old number for new# N12 and it would extract the information from sheet 2 with the formula:VLOOKUP(A2,Materialmaster,2,FALSE) Sheet 1 ------Sheet 2...
  2. L

    Help a newbie

    I need help. Now I've written a post so that some one could help retrieve current information and they told me to use Dmax. Great but I don't know how to use Dmax. Basically I need step by step instructions. This is an example of what my table looks like: Date of Order --Product--- UNIT COST...
  3. L

    How can a query for the most recent date?

    I have the following columns: Date Price Item # Item description Weight Cost Now, what I need is a report that will give the last price of an item. I import the new pricing on to a table once I receive, but not all the items get new princing all the time. This means I can't query for the...
Back
Top Bottom