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