Can Vlookup accomplish this?

[osp]

Ok here is a screenshot and hopefully this will help me explain what
am trying to accomplish.

http://home.mindspring.com/~timbu/sitebuildercontent/sitebuilderpictures/sales_04.jpg

In the highlighted cells on Sales_04.xls I'm trying to use a functio
to retrieve data from sales.xls (the cells colored in yellow). Vlooku
will not accomplish this since the cells in yellow are not in the sam
row as the Item numbers (cells colored in green). This is just a
example of what I'm working with and the worksheets at work are
couple thousand rows so I'd really like to use a function to accomplis
this if it's possible

 

[Biff]

Hi!

Try this:

=OFFSET([Sales.xls]Sheet1!$A$1,MATCH(A2,[Sales.xls]Sheet1!
$A$1:$A$15,0)+3,4,1,1)

Adjust the MATCH lookup_array to suit.

Biff

 

[Myrna Larson]

Don't know what you are looking up, but

=INDEX(E:E,MATCH(<whatever>,A:A,0)+4)