Michael Dean
asked on
lookup functions in Excel
I have a spreadsheet that I have attached.
Worksheet: FA
I want to find the corresponding row in worksheet "revenue". Find the matching row in worksheet "Revenue" for each Individual Last Name in Worksheet "FA" and return the corresponding Revenue (col J)
Example:
FA!Column C Revenue!ColumnH Revenue!Col J
ALEXANDER-DONCEL ALEXANDER-DONCEL $256,404.94
Renewal-Fees--2011-.xls
Worksheet: FA
I want to find the corresponding row in worksheet "revenue". Find the matching row in worksheet "Revenue" for each Individual Last Name in Worksheet "FA" and return the corresponding Revenue (col J)
Example:
FA!Column C Revenue!ColumnH Revenue!Col J
ALEXANDER-DONCEL ALEXANDER-DONCEL $256,404.94
Renewal-Fees--2011-.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.