Quote:
Originally Posted by Pecoflyer
I don't see why the SUBSTITUTE in col D is necessary
Code:
=VLOOKUP(MID(A60,3,2),H:I,2)
does the job
@tispivey
Using entire columns as reference is bad practice
Use Excel Tables instead as dynamic reference
As for the IFERROR function, do not apply it before you have ascertained that your formula works correctly
In this case if you want to hide the NA error, OK, but suppose, for some reason, it returns a VALUE error? IFERROR will hide that also leading to incorrect results
IMO the ISNA function is safer |
I have tried ISNA and IFERROR, and IFERROR seems to work better for what I am using this for. This report goes to a lot of VPs in the company i work for, and the cleaner it is, the better, but I truly appreciate the feedback.