copy sales volume data from sheet 2 to sheet 1 by sales person
 

Sheet two has sales person and last month volume. Sheet one has sales person
and current volume. i want to find corresponding sales person on sheet 1 and
copy the volume from sheet two.
Any other way to do this besides a macro?

copy sales volume data from sheet 2 to sheet 1 by sales person
 

VLOOKUP(), LOOKUP() and INDEX/MATCH are three ways that come to mind.

--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"pm" wrote:

Sheet two has sales person and last month volume. Sheet one has sales person
and current volume. i want to find corresponding sales person on sheet 1 and
copy the volume from sheet two.
Any other way to do this besides a macro?