Hi all,

I will be posting many questions as I just got a temp job from friend
automating a complex Excel report, that is now done manually, and that
relies on several other Excel reports to populate it's data. Each
report is a seperate Workbook.

I know very little about Excel, beyond the absolute basics. I got the
job as a favor, and because my friend has confidence that I can figure
it out (which I am doing on my own time).

My first problem is this. One requirement is that when the main report
is run that it grabs the date automatically from each sub-report and
inserts into the proper section. The date field is only one cell in
each report, and only needs to populate one cell in the correct section
on the final report.

I have tried variations on MATCH, LOOKUP, VLOOKUP, HLOOKUP and even
tried the LOOKUP wizard addin (which was no help). I always get the
same result... #N/A. I have looked at all the Excel help files that
seemed relevent, and combed the web (including here) trying to find the
answer. Part of the problem is my complete lack of experience with
Excel, and because of that, I'm not sure that I understand some of what
I've read. I may have found the answer and not understood it.

I have had no problem (so far) using VLOOKUP to grab the column values
I need from the various reports. I don't understand why I can't, or how
I go about grabing a single value from a single cell!?


---
Message posted from http://www.ExcelForum.com/