Need Lookup & Product formula combined

  • Thread starter Thread starter JANA
  • Start date Start date
J

JANA

See below: I need a formula for Spreadsheet A in column
C that will compare the name in spreadsheet A cell A1 to
the names in spreadsheet B column A and if a match is
found, multiply the corresponding rate in column B by the
hours in Spreadsheet A cell B1 and put that total in C1.
PLEASE HELP! THANKS!

SPREADSHEET A
COLUMN A COLUMN B COLUMN C
1 EMPLOYEE NAME HOURS formula??

SPREADSHEET B
COLUMN A COLUMN B
1 EMPLOYEE RATE
 
Back
Top