Take a look at this:
http://www.contextures.com/xlFunctions03.html

The Index/Match function should permit you to overcome the imitations of the
vlookup function.

Regards,
Ryan---


--
RyGuy


"AAlex" wrote:

I am attempting to automate some documents in order to grab data which is
imported into another Excel Spreadsheet. My forumla seems to work well until
the data is not in the exact same place as the previous document, sending it
into a flux. The next time however usually works properly. Here is the
formula I've been using:

=VLOOKUP("Total",'C:\Documents and Settings\Desktop\June\[6-05-08.xls]HRC
Performance'!$A$1:$O$48,3,TRUE)

I have also tried using False or 0 as my last varible but nothing seems to
work correctly. Basically what typically happens is that it pulls data from
a row 5 rows up. Any suggestions would be greatly appreciated. Thanks