VLOOKUP HELP
Solved/Closed
PAUL
-
3 Jan 2010 à 03:50
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 3 Jan 2010 à 21:47
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 3 Jan 2010 à 21:47
Related:
- VLOOKUP HELP
- Iserror function in excel with vlookup - Guide
- Transfer data from one excel worksheet to another automatically vlookup - Guide
- Vlookup compare two columns and return a third ✓ - Excel Forum
- Match value in 2 separate columns and return a value from a 3rd - Excel Forum
- Vlookup from multiple columns with only one return - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
3 Jan 2010 à 21:47
3 Jan 2010 à 21:47
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