VB script to read data from another sheet

Closed
srini4547 Posts 1 Registration date Thursday January 31, 2013 Status Member Last seen January 31, 2013 - Jan 31, 2013 at 09:36 PM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Feb 2, 2013 at 12:28 PM
Hello,

please provide solution , please find my requirement

Sheet1

column name values

A 1
B 21
C 13
D 14
E 15

Sheet2

A
B
A
B
A
B



I need to refer value from sheet1 in to sheet2, how to achieve please provide the solution

1 response

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Feb 2, 2013 at 12:28 PM
Hi srini4547,

As you have posted in Forum > Office software > Excel, I assume your sheets with values are in Microsoft Excel. Instead of using VBScript for this purpose please use VLOOKUP() worksheet function. You can read more about VLOOKUP() worksheet function from the below mentioned link:

http://office.microsoft.com/en-001/excel-help/vlookup-HP005209335.aspx

Please reply if you have any further questions.
0