Fwd: $$Excel-Macros$$ Vlookup function using with match & columns

2013-07-11 Thread Muralidhar E
Dear Friends, It is possible to lookup the values for the left side and second value, third value Is their any other ways or functions to get the results.? 1. Shall we can get the left side result by using vlookup function? 2. Shall we can get the second value result by using vlookup function

Fwd: $$Excel-Macros$$ Vlookup function using with match & columns

2013-07-10 Thread Muralidhar E
Dear friends, Good afternoon, I need a help and I want to know how to use vlookup function by using match and columns function. How it is works? Plz, share with me. *1.This is using match function* =vlookup(lookup_value,Table array*,match(lookup_value,lookup_array,match type),*range lookup). *2