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
Views: 12
ALL BUSINESS MICROSOFT EXCEL TIPS
VLOOKUP with 2 criteria
Comments are closed.