Please forward the formula Thanks for all of them Salman
J Jacob Skaria Mar 29, 2009 #2 Dear Salman Let the data be the below starting from A1 ColA ColB 1 One 2 Two 3 Three In C1 enter one of the values 1,2,3 D1 enter the formula =VLOOKUP(C1,A1:B3,2,FALSE) If this post helps click Yes
Dear Salman Let the data be the below starting from A1 ColA ColB 1 One 2 Two 3 Three In C1 enter one of the values 1,2,3 D1 enter the formula =VLOOKUP(C1,A1:B3,2,FALSE) If this post helps click Yes
S Simon Lloyd Mar 29, 2009 #3 Salman;287733 said: Please forward the formula Thanks for all of them SalmanIf your asking for the structure of a VLOOKUP then its this: Click to expand... =VLOOKUP(the value to lookup, the range to lookup in, which column the holds the result in the lookup range, FALSE for exact match or TRUE for nearest match) -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com)
Salman;287733 said: Please forward the formula Thanks for all of them SalmanIf your asking for the structure of a VLOOKUP then its this: Click to expand... =VLOOKUP(the value to lookup, the range to lookup in, which column the holds the result in the lookup range, FALSE for exact match or TRUE for nearest match) -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com)
