Excel newbie help - formula

[1967Mustang]

Hello everyone,



I'm new to the Excel community and trying to take values off of one worksheet (worksheet2) and put them into another worksheet (worksheet1). Worksheet2 (attached) has multiple name values and rates. For example, I'm trying to pull name with associated rates (can be multiple) and place them in WorkSheet1 (see attachment). Any recommendations would be greatly appreciated

Thanks.

[OTPM]

Hi
Using your example:
Put this formula into B2 on Sheet 1 and copy down :
=VLOOKUP(A2,Sheet2!A:E,5,FALSE)
Put this formula ionto C2 on Sheet 1 and copy down:
=VLOOKUP(A2,Sheet2!A:E,3,FALSE)
Good luck
Tony

[Pecoflyer]

If I understand correctly, the OP is trying to synthesize the number of hours for a given person/rate
Possibility one : use a Pivot Table
Possibility two : in C2 sheet1 enter =SUMPRODUCT(SHEET2!$A$2:$A$100=A2,SHEET2!$E$2:$E$1 00=B2,sheet2!$C$2:$C$100)

and pull down as needed - Adapt the ranges to your needs - You can also use the SUMIFS function