Search results

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...

Neil, I figured out what I needed to do but now I have duplicates because it's picking out a date from each year, and not the latest date.

I re-read your suggestion and I finally got what I need.... Thanks a million!

Maybe I should elaborate a bit more. I import all my information periodically to the same table. sometimes the prices changes sometimes it doesn't. The date is the only field that changes everytime. Date of Order --Product--- UNIT COST 20-May-05----- XYZM---- $8.87 20-Jun-05------ XYZM...

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...

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...