VLOOKUP HELP
Solved/Closed
PAUL
-
Jan 3, 2010 at 03:50 AM
venkat1926
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
1 reply
venkat1926
Jan 3, 2010 at 09:47 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Jan 3, 2010 at 09:47 PM
in sheet2 B2 paste this formula
and hit enter key
=SUMPRODUCT((Sheet1!$A$2:$A$22=A2)*(Sheet1!$C$2:$C$22))
and hit enter key