Here I will give you small example.
Here in the picture you can see that I made a chart which contains serial number, name of the thing, group, unit and price. Below I will enter the serial number and it will lookup the name by using VLOOKUP.
If my input does not belong to the list or you can say is an error then I may use the function to show the error input. I have used the formula =IFERROR(VLOOKUP(B20,B3:F16, 2,FALSE), “Invalid No”). If the input is not from the list of serial numbers (1-14) then It will show the text “Invalid No”.
Related video tutorials: