![]() ![]() Now, see the cell F3, we are doing a ‘vlookup’ just like above, it will give the result “92”. Now, let’s suppose we have decided on a condition, that if the marks scored is greater than 92, then it will be shown as “Great” otherwise, it will be shown as “Good.” Now, when I see the marks, I am not interested in their actual marks, but I just want to see whether they are great or good. The data table remains the same, as explained during the ‘vlookup’ function. ![]() Now that I have explained to you the formula template and some of the use cases, let’s try to explain it better through examples and then explaining it in a lucid way. How to Use Vlookup with IF Statement in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |