VB script to read data from another sheet

Closed
srini4547 Posts 1 Registration date Thursday 31 January 2013 Status Member Last seen 31 January 2013 - 31 Jan 2013 à 21:36
Zohaib R Posts 2368 Registration date Sunday 23 September 2012 Status Member Last seen 13 December 2018 - 2 Feb 2013 à 12:28
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 23 September 2012 Status Member Last seen 13 December 2018 69
2 Feb 2013 à 12:28
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.