Member Avatar for 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

Edited by Reverend Jim because: moved from vb.net
  • 4 Contributors
  • 8 Replies
  • 245 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by TnTinMN
Member Avatar for adam_k

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

Edited by adam_k
Member Avatar for anisha.silva

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

Member Avatar for 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.

Member Avatar for AndreRet

Please mark as solved anisha, thanx. :)

Member Avatar for anisha.silva

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

thanks

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.