macro get value

[anisha.silva]

hi,

I have a sheet name 'rate' and another sheet name "master".
rate sheet has data as below

EmpCol1 rateCol1
a    1
b    2
c    3 etc...

and master has data as

empCol2 rateCol2
c
a
b

What i want to do is to get the rateCol1 from rate sheet and display infrom of the correct empCol2 .

how do i go this? do i have to write an lookup?
thanks

[adam_k]

Yes, a vlookup will be perfect for this, but this post doesn't belong in the VB.NET forum.

[anisha.silva]

thanks, where should i post questions relating to excel macro
how do i create array's in macro

[TnTinMN]

VBA is a subset of VB6, so I think that would be the best place.
http://www.daniweb.com/software-development/visual-basic-4-5-6/4

[adam_k]

Read here: http://support.microsoft.com/kb/213798 , but I find it way easier to use the worksheet itself (or a new one if you don't want to mess with the existing).

In your case you just need to vlookup, which isn't a macro.

[anisha.silva]

thanks

[AndreRet]

Please mark as solved anisha, thanx. :)

[anisha.silva]

hi AndreRet i will still didn't solve my question
one i get it, will mark this as solved

thanks

[TnTinMN]

http://letmebingthatforyou.com/?q=excel%20lookup%20table

Hint: Look at the Microsoft support article.