Find Matching entries

I have been asked to create a worksheet which on sheet 1, lists all items used by our business and the dates that they were last modified.

On the second sheet, I have to list all the items used by our area of the business. I have been asked to create something that will look at all the forms I have input on this sheet and match them on sheet 1 and locate the most recently updated version.

Can anyone point me in the direction of what functions would be best suited for this? I think I may be looking to far into it when there are simple functions to carry out the task. If anyone needs any further info, please ask.

I've sat back and thought about this query and have revised what I require.

First, the sheet tells me how many times an input appears in the sheet.

eg - I enter product name in cell H1 and it looks at all the entries in column B and states how many times that product appears.

Second, the date that the product was last modified. All modification dates are in column C.

If any one can help I'd be greatful.

Thanks

Do you want this to be full automated or do you mind clicking a button after inputting information into cell H1?

To be clear, in sheet 1 do you just want a place to retrieve the information or would you like all sheets to publish the product, how many, and last mod date?

If the first is what you want, to use sheet 1 as a place to retrieve information, I would look into a VLOOKUP. As for the second, a macro would be required.

Originally Posted by goofy78270

Do you want this to be full automated or do you mind clicking a button after inputting information into cell H1?

To be clear, in sheet 1 do you just want a place to retrieve the information or would you like all sheets to publish the product, how many, and last mod date?

If the first is what you want, to use sheet 1 as a place to retrieve information, I would look into a VLOOKUP. As for the second, a macro would be required.

Well so far, I have a VLookup to locate the product. What I want to do now is have the sheet update to show the newest version whenever it is amended and also show how many entries the product has so we can track how many times it has changed. So now I have

=IF($G$3="","",VLOOKUP($G$3,$B$24:$C$2500,2,FALSE)). I need to add a max function into it, to show the latest update.

If you can show where the max function will fit in this (Column 2 being the update values) that would be a step in the right direction.

Thanks