View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JNW JNW is offline
external usenet poster
 
Posts: 480
Default #VALUE error on VLOOKUP of text

We'll need your vlookup formula...
--
JNW


" wrote:

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!!