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
seamus9909Asked:
Who is Participating?
 
TobiasConnect With a Mentor Commented:
Dear,

I have modify the file like request.

Best Regards
Renewal-Fees--2011-.xls
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.