If Vlookup doesn't find any value, return blank cell

=VLOOKUP(MID(A156,13,1),'Nema rating'!$A$2:$B$15,2,FALSE)

How would i adjust this formula to where if the v lookup does not find any matches it will leave the cell blank?

If there are no matches the formula will produce an error (#N/A). You can trap this by doing:

=IFERROR(VLOOKUP(MID(A156,13,1),'Nema rating'!$A$2:$B$15,2,FALSE),"")

Hope this helps.

Pete

Thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete