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?