Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/07/VLOOKUP-and-IF.xlsx

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.

3) In the third scenario I want to look up three different tables. Using IF or IFS I can create a series of tests that tell Excel which table to perform the lookup on. Alternatively, I can use the CHOOSE function.

4) In the fourth scenario I use VLOOKUP and IF in conjunction with a drop-down. The drop-down value defines which column within the lookup table to return values from.
------------------------