VLOOKUP with 2 criteria (Sales Agent and Region) – Excel
Formula for column I7 (Revenue)
=VLOOKUP(H7;C7:D13;2;FALSE)
Formula for column C7 (Helper)
=A7&”|”&B7
Formula for column H7 (Helper)
=F7&”|”&G7
About Us
We must explain to you how all seds this mistakens idea off denouncing pleasures and praising pain was born and I will give you a completed accounts off the system and expound.
Contact Info
- 81 Lake Floyd Circle, Gaithersburg
- (000) 000-000-0000
- info@example.com
- Week Days: 09.00 to 18.00 Sunday: Closed
Useful Links
- Training
- Legal/Politics
- Compensation
- Safety
- Environmental
quick contact
- Agencify HR Serice
- 509 Clematis St, West Palm Beach FL 33401, USA
- +1 561-318-5142
- hr@agencifyllc.com
Office Hours
- Mon - Thur: 8:30a - 5:00p Fri: 8:30a - 12:00p
You can help customers in real-time across all of your channels from email, social, website, iOS, and Android apps.