Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need help with a search function - vlookup or ???
Hi everybody,
sorry if I don't post in the right thread, I just don't really know where to ask for help _< (and sorry as well for my sometimes very bad english) I'm currently working on Excel to update some material expiry dates, and I'm looking for a solution that could avoid me hours of using the mouse's scroll. To start with, I've download a spreadsheet from our ERP and the resulting information is presented like below: XXX555655 (material number) (mandatory field from erp) (price) (currency) (nb item) (packaging) (set-up date) (expiry date) PR11 100.17 EUR 1 EA 03.04.2006 01.04.2007 PR11 97.25 EUR 1 EA 02.04.2007 21.05.2007 PR11 100.17 EUR 1 EA 22.05.2007 31.12.2009 PR11 97.25 EUR 1 EA 01.01.2010 31.12.9999 I've got almost 1200 lines like that, and if I want to use the AutoFilter, I first need to go throught everything to put the material number instead of the "PR11" field. But it's really time consuming and useless as this way I could check my expiry dates at the same time. what I'd like to know is if there's a way to ask Excel to find me the very last date for X product, looking through all the lines for a single product. e.g, for that particular code XXX555655, I want to get as a result "31.12.9999". so I wonder if there's a formula that I can use, maybe before using a filter to sort everything? I tried with vlookup, but I'm not really good at it, so if anyone could help me with this, it would be brilliant. Hope I'm clear enough in my query, thanks a million for your help!! -- Dawns are only the illusion of the beauty of the world. When the world opens eyes, reality takes back its rights. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I use a VLOOKUP function to search a multi-page workbook? | Excel Worksheet Functions | |||
How can I use a VLOOKUP function to search a multi-page workbook? | Excel Worksheet Functions | |||
Vlookup & search function help | Excel Worksheet Functions | |||
vlookup with search? | Excel Worksheet Functions | |||
VLookup function to search an entire workbook | Excel Worksheet Functions |