Thank you!
It worked out great! Using the below example of the formula, what can be done to the formula so it elimates the #N/A error?
Is it possible to replace the #N/A with the words "no match"?
=VLOOKUP(A2,'Sheet1'!$A$2:$B$141,2,0)
Thank you for your help!
|