I'm trying to run the following formula
"=IF(ISBLANK(B383),"---",VLOOKUP($B383,PVC2,3,FALSE))" and I keep getting the
error listed in the subject line.
We are doing inventory and on a couple of pages the people counting wanted
them by description instead of part number. I've put the parts on a
seperated worksheet and named the range for the parts to PVC2. I didn't what
to have to manually configure them jumping around. This would of been easy
except our accounting software kept the part numbers and descriptions in the
same cell. I actually exported 2 differents sheets from the software. one
listing every thing by part number and the other by description. I'm not
sure what is wrong. I've tried going through the evaluate formula and it
show's the #ref in there but not sure how to fix it.
239-503017 - BULKHEAD BOLTED FITTING 2" W/SIPHON #REF! 1.00