I am receiving a #VALUE error when doing a VLOOKUP on 5 different
workbooks in a single cell. Only one workbook contains the data I am
looking for each data value. I have used ISERROR, ISNA and have been
unsuccessful in returning data. any idea's??

THANKS!!