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