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 reply

Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
68
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