Microsoft Excel - lookup value help along with if string

Hi,

I have an excel sheet with first tab (tab name: first) which has column A with values : 1, 2,3,4, ..., 10 

In second tab (tab name: second), I have same Column A as 1, 2, ..., 10 but also have column B with corresponding values as 11,22,33,44,55,...

Now, in my third tab (tab name: third), I have random column having values 1 to 10 ..in any order.. 1, 5, 2,1,4,5,8,10... the values can appear more than once in this column.. 

Now, basically in my third tab, I want to create a new column such that if the value on A1 of this tab is 1, then it should automatically pull data 11 into B1, if the value is 2, it should automatically pull the data as 22 and so on

I have been struggling for last three hours and will sincerely appreciate any help at all.

Thank you.

Ram  

 

try this on third sheet cell b1, then drag it down for ten rows and see what happens.  if you need more range you can change is from B10 to what ever you need.


=VLOOKUP(A1,second!$A$1:$B$10,2)

Hi Donald, Did the Job, Thanks a lot.