$$Excel-Macros$$ Vlookup

Thanks for the Reply, But for the range it is not working. Please help me to fix it. Regards, Ashwin --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA

$$Excel-Macros$$ Re: Vlookup Value

Hi Dilip, My requirement is, I want to Vlookup and the value returned is based on M or D. Example Vlookup of table value "A" (Column B) and value "D" (Column C) the value required as result is 26. But i will get answer as 25. Please help me to get it. Regards, Ashwin On S

$$Excel-Macros$$ Vlookup Value

--~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at htt

$$Excel-Macros$$ Vlook up and filtering

Hi All, I need to use Vlookup, The conditions is that the lookup range has multiple value (Duplicate entries) and i need to select (lookup range value ) based on next colum. Please help to to get it. Regards, Ashwin