VLOOKUP multiple values
You can use VLOOKUP and view an entire record of someone or something. Below I have a list of folks with some details. The corresponding functions I have highlighted with colour blocks. Each corresponding colour is the function that you type in.
Just a note. The “EMPTDATA” is the named range of all the data (C7:G15). The numbers 2-5 are the corresponding columns. 2 = column D, etc.
Below, you can see how the IFERROR() works. I entered in a name that is not in the list and you get the custom error.