VLOOKUP HELP
Solved/Closed
PAUL
-
Jan 3, 2010 at 03:50 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 3, 2010 at 09:47 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 3, 2010 at 09:47 PM
Related:
- VLOOKUP HELP
- Transfer data from one excel worksheet to another automatically vlookup - Guide
- Conditional Formatting in a vlookup - Excel Forum
- Vlookup to find missing data in 2 columns - Excel Forum
- Vlookup if two cells match return value from third ✓ - Excel Forum
- Removing "FALSE" from an IF statement with a VLOOKUP ✓ - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jan 3, 2010 at 09:47 PM
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