0

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

Edited by Reverend Jim: moved from vb.net

4
Contributors
8
Replies
10
Views
4 Years
Discussion Span
Last Post by TnTinMN
0

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

Edited by adam_k

0

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

0

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

thanks

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.