Excel Formula, or Macro

 helper -
i need a formula or a macro for Excel 2003 that will do the following:

i have a list of logins in column B, lets just say 1,2,3,4,5 going down the column. in Column C there is a performance percentage for each Login.

a few columns over in Column F is a list of names. and in column G beside the names is where i need this formula, or where i need the macro to do its job.

what i want is to have to have the performance percentage copied from Column C over to Column F. but each Name is Column G corresponds with a login in Column B. so i need the correct performance percentage for the Login to be copied over to the correct Name that corresponds with that specific login.

Hope that is not too much to ask :)


1 reply

use the =vlookup function, there are tons of internet tutorials for it online, it sounds exactly like what you are looking for

Good luck