In following image VLOOKUP function used to find the required data.
For Example If we enter john it shows the result of john's data.
But if we enter the name which is not listed then it shows #N/A.To avoid #NA, IFERROR function can be used.
By using IFERROR function we can show our desired message.You can see it in below image.
No comments:
Post a Comment