VLOOKUP, IF? Question assigning value to text options
Solved/Closed
Related:
- VLOOKUP, IF? Question assigning value to text options
- Shortcut to internet options - Guide
- Netflix payment options - Guide
- Open internet options as admin - Guide
- Yahoo mail forgot password and security question - Guide
- Ps4 safe mode options - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jan 17, 2018 at 03:44 PM
Jan 17, 2018 at 03:44 PM
Soupies, Good evening.
This can be one of the ways to solve this question:
=SUMPRODUCT((($E$1:$E$11=A1)+($E$1:$E$11=B1))*($F$1:$F$11))
With a Table at E1:F11
E1:E11 --> Differents NAMES
F1:F11 --> Related VALUES
I set an example for you:
https://www.sendspace.com/file/x540nt
Please, take a look and tell us if it works as you desire.
I hope it helps.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
This can be one of the ways to solve this question:
=SUMPRODUCT((($E$1:$E$11=A1)+($E$1:$E$11=B1))*($F$1:$F$11))
With a Table at E1:F11
E1:E11 --> Differents NAMES
F1:F11 --> Related VALUES
I set an example for you:
https://www.sendspace.com/file/x540nt
Please, take a look and tell us if it works as you desire.
I hope it helps.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
Jan 17, 2018 at 04:08 PM
Thank you for your reply! I will try your approach now and see it if will work, but looks promising. I truly appreciate that you made an example for me.
Soupies