I'm trying to create a formula that would look in a column of another tab for
one of two last names and if it equaled a name then it would look in another
column for a dollar amount and add it to the cell. For example; If Tab 1
column A equals Champ then add column C and if Tab 2 column A equals Champ
then add column D. Thanks for your help in advance.
--
Respectfully,
Rick Champ