IF and VLOOKUP Nested Function | VLOOKUP with a Drop-down

Microsoft Excel Tips and Tricks

In this video I explore combining IF with VLOOKUP. 1) In the first scenario I explore using an IF to perform a VLOOKUP if a condition is met: if a sales person has met a sales target lookup what commission percentage they should receive. 2) In the second scenario I compare two lists using VLOOKUP and then want to convert the NA errors to values. I can use ISNA as my logical test and then IF to return the desired value.

Credit Chester Tugwell