I have a spreadsheet containing production information. I want to be
able to search by date (can do this using VLOOKUP), and extract
information from the same row as that date.

However, I also want to be able to extract the previous 10 entries as
well, for comparison purposes.

ie I enter a date and find that it is in B95, and the piece of info I
want is in C95. I also want to be able to pull out C86-94 and place it
all into a new sheet.

I'd be grateful for any help offered. Thanks


--
dudara
------------------------------------------------------------------------
dudara's Profile: http://www.excelforum.com/member.php...o&userid=37475
View this thread: http://www.excelforum.com/showthread...hreadid=571357

You may use the INDEX and MATCH functions, there is a good explanations of
these two functions together at:
http://www.contextures.com/xlFunctions03.html
In your case, you may need to substract the numbers of rows from the match
results to get the previous information (that case is not covered in the
examples)

Hope this helps,
Miguel.

"dudara" wrote:


I have a spreadsheet containing production information. I want to be
able to search by date (can do this using VLOOKUP), and extract
information from the same row as that date.

However, I also want to be able to extract the previous 10 entries as
well, for comparison purposes.

ie I enter a date and find that it is in B95, and the piece of info I
want is in C95. I also want to be able to pull out C86-94 and place it
all into a new sheet.

I'd be grateful for any help offered. Thanks


--
dudara
------------------------------------------------------------------------
dudara's Profile: http://www.excelforum.com/member.php...o&userid=37475
View this thread: http://www.excelforum.com/showthread...hreadid=571357