Sometimes while working with data when we match the data to the reference Vlookup if finds the value first it displays the result and does not look for the next value but what if the user wants the second result this is another criteria to use Vlookup with multiple criteria we need to use other functions with it such as choose function. The Excel formula to achieve this in our example can be written as IFNAVLOOKUPE2B5F175FALSECustom message Alternatively if your version of Excel doesnt include the IFNA function you can achieve the same result using IF ISNA. Select cell E4 and enter the VLOOKUP function shown below.
Click on formula tab lookup reference click on vlookup.
Step 3 Enter the Arguments. The Excel formula to achieve this in our example can be written as IFNAVLOOKUPE2B5F175FALSECustom message Alternatively if your version of Excel doesnt include the IFNA function you can achieve the same result using IF ISNA. Click on formula tab lookup reference click on vlookup. When using the VLOOKUP function in Excel you can have multiple lookup tables.