I am using a vlookup formula in a column to check to see if there are any missing links of data in another file. If the vlookup returns the not available/error value #N/A, then I want a message box to display the information in the corresponding column of that row.

For example, the values being vlookuped are in column A and my vlookup formula is in column L. If cell L3 = #N/A I want the message box to display the value in cell A3, but I want the message box to check all the errored values and present them all together one time.