VB script to read data from another sheet [Closed]

Report
Posts
1
Registration date
Thursday January 31, 2013
Status
Member
Last seen
January 31, 2013
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
-
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

Posts
2368
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
36
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!