ALL ENGLISH EXCEL TIPS

VLOOKUP with 2 criteria

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

Comments are closed.

Pin It